Code to extract text

Topic

New Reply

Hi, I have the title, first and surnames of a list of people in one column, it is proving difficult for sorting. Is there code I can use to extract the title?

Many thanks, Darren.

Reply | Quote

Replies

Hi, I have the title, first and surnames of a list of people in one column, it is proving difficult for sorting. Is there code I can use to extract the title?

Many thanks, Darren.

If the Title is the first item listed and is always seperted by a comma (,) from the first and surnaems; the below formula will extract the Title which then can be used to sort the data.

=LEFT(A1,FIND(“,”,A1)-1)

Tom Duthie

Reply | Quote

If the Title is the first item listed and is always seperted by a comma (,) from the first and surnaems; the below formula will extract the Title which then can be used to sort the data.

=LEFT(A1,FIND(“,”,A1)-1)

Tom Duthie

Alternatively, if there’s a space separator:
=LEFT(A1,FIND(” “,A1)-1)

Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Reply | Quote