Dump it into Word. Convert table to text. Convert text to table and use a
space as the separator then dump to excel

"Patty via OfficeKB.com" wrote:

I have over a thousand cells with last name,first name. I want two different
cells with last name in one and first name in the other (minus the comma).
Any ideas? (no VB please!)

Thanks.


--
Message posted via http://www.officekb.com