Separate First, Last Names

[BStacy]

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.

 

[Francis]

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

 

[Per Jessen]

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

Regards,
Per