Thread: Format Name
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dax Arroway Dax Arroway is offline
external usenet poster
 
Posts: 70
Default Format Name

Can someone please help with a formula?

In Column A I have names formatted as SMITH, John. In Column B I need John
Smith. Would someone please help with a formula that would switch the names,
get rid of the comma, and change the case to lower case of the last name
except for the first letter?

Thanks in advance!
- D.