Mid String

[Guest]

Hi Anyone!

I have a column "Name" that's including Fisrt Name Middle Name Last Name
Ex: John M Smith
How can you retreive the middle intial. I know how to get the Last Name and
First Name but I don't know how to get the Middle Initial. Please advise.
Thanks

Ngan

 

[Guest]

If the format is always as shown with first name, a single space, then a
single initial, =MID(A1,FIND(" ",A1)+1,1) will pull out that single initial.
If you need to do this after a mass import, you might also check out Data >
Text to Columns.
--Bruce