Extract data from a cell
Perfect!! Thanks Eduardo and Glenn!!
"Eduardo" wrote:
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
|