Text Function

[Regor]

Hi

I have imported an excel list with the first field being the person's Name. It contains Title, first middle and last names. I want to get rid of the title (Mrs, Mrs, Ms etc) which is always the first word so that I just have the name only

Sometimes the field contains 3 words, but if the middle name is there, then there are 4 words in the field includinf the Title

Can someone please help?

Thanks

[Lee Smith]

This topic comes up from time to time.

Do a search for the Keywords of +Parse +Names, start with this one here: Link

HTH

Lee