Hi,

You may also use this

=LEFT(C18,SEARCH(",",C18)-1) for the names; and
=RIGHT(C18,LEN(C18)-SEARCH(",",C18)-1) for the address

The assumption herein is that the names and address are separated by commas
and that there is only one comma in the string

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sjs" wrote in message
...
I have a cell that contains two pieces of data separated by a comma (ex:
first name, address). I'd like to extract the data into two cells so that
the first name is in one cell and address is in a second cell.

Any help would be greatly appreciated!

tks,
steve