I fully understand how to use concatenate. However I am needing to find
out the opposite of it. I have a sheet where column A is the full name
of a customer. I want the name broken down into seperate cells for
first and last names.

What I have:
A1 = John Smith

What I want
B1 = John
C1 = Smith

Thanks for all your help.


--
shane24
------------------------------------------------------------------------
shane24's Profile: http://www.excelforum.com/member.php...fo&userid=4770
View this thread: http://www.excelforum.com/showthread...hreadid=490090