View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sross002 sross002 is offline
external usenet poster
 
Posts: 29
Default Name Format Formula

I have a full name in A1 but I want it to read as: Full Last Name, First
Name Initial.

For example, I would like to convert John Appleseed (a1) to Appleseed, J

Thank You in advance.