Thread: Mid String
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Access Front End
 
Posts: n/a
Default Mid String

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