View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme
 
Posts: n/a
Default HelpNeed to know what formulas I need to use to move names in a co

This works with your two example (name in A1)
=MID(A1,FIND(" ",A1)+1,255)&" "&LEFT(A1,FIND(" ",A1)-1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Help Me - I need to switch these names"
ft.com wrote in message
...
Working with a data base that has names in a column as follows:
Smith James & Sara or Jones Sam R & Mary J
and I need them to read
James & Sara Smith and/or Sam R & Mary J Jones
can someone tell me the formulas I need to use in order to accomplish this
or where I can find help in Microsoft office to accomplish this.
Thank you in advance for any assistance