View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ashish Mathur[_2_] Ashish Mathur[_2_] is offline
external usenet poster
 
Posts: 1,766
Default Question about Flipping Names in same cell

Hi,

If there is no middle name, then select column A and then Data Text to
columns. While on delimited, click next and on the next screen, uncheck all
boxes except spaces. Click on finish. Now in a spare column, enter B1&"
"&A1

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Catherine Damiani" wrote in message ...
say i have John Smith in A1 and want it to be Smith John in A2, what would
the formula look like that would be in A2?

thank you!!!