View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
G. B. Needs Excel Help G. B. Needs Excel Help is offline
external usenet poster
 
Posts: 1
Default If..The Statement to automatically format a name

I am looking for an Excel if..then statement to evaluate a name and insert a
period after a single letter if the name contains a single letter. Example
John Q Smith.

Can excel do this for a list of names that are not the same length. Please
help. These are more examples.
John T James
Janice S Smith
Lola P Simpson