Hi,
Highlight the column, data, text to columns, delimiter, choose comma, Ok

if this helps please click yes thanks

"sjs" wrote:

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