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!!!