I have a spreadsheet of thousands of names. There is a NAME field which
needs to be separated into Last, First and Title.

The names are formatted like: Doe , James E, MD
(the space after last name is intentional)

I separated the last name into a separate field but can't figure out how to
get the first name and initial into another field and the title (MD) into a
3rd field. The First Name and Middle Initial don't have to be separated and
can be in a First Name field together.

try
Select your range
Data from Tool Bar
choose Text to column
select Delimited
click next
check Other
type ,
clcik Next
Finish
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"BStacy" wrote:

I have a spreadsheet of thousands of names. There is a NAME field which
needs to be separated into Last, First and Title.

The names are formatted like: Doe , James E, MD
(the space after last name is intentional)

I separated the last name into a separate field but can't figure out how to
get the first name and initial into another field and the title (MD) into a
3rd field. The First Name and Middle Initial don't have to be separated and
can be in a First Name field together.

Select the column, goto Data TextToColumns Delimited Next
Delemiters: Comma Next Destination: Select cell to hold first "First
Name" Finish

Regards,
Per

"BStacy" skrev i meddelelsen
...
I have a spreadsheet of thousands of names. There is a NAME field which
needs to be separated into Last, First and Title.

The names are formatted like: Doe , James E, MD
(the space after last name is intentional)

I separated the last name into a separate field but can't figure out how
to
get the first name and initial into another field and the title (MD) into
a
3rd field. The First Name and Middle Initial don't have to be separated
and
can be in a First Name field together.