I'd like to split the content of a cell to an adjacent cell. For instance in
column B there is a list of first name and last name; all found within a
cell. I'd like to split the content so that the first name remains in column
B and the last name is pasted onto column C.

Thanks,

Select your column of data and then click DATA in the menu and select TEXT TO
COLUMNS.
--
Kevin Backmann


"Catracho4444" wrote:

I'd like to split the content of a cell to an adjacent cell. For instance in
column B there is a list of first name and last name; all found within a
cell. I'd like to split the content so that the first name remains in column
B and the last name is pasted onto column C.

Thanks,

if first name and second name is separated with a space then type in column B:
=left(A1, find(" ", A1, 1))
and type in column C:
=right(A1, len(A1)-find(" ", A1, 1)).

"Kevin B" wrote:

Select your column of data and then click DATA in the menu and select TEXT TO
COLUMNS.
--
Kevin Backmann


"Catracho4444" wrote:

I'd like to split the content of a cell to an adjacent cell. For instance in
column B there is a list of first name and last name; all found within a
cell. I'd like to split the content so that the first name remains in column
B and the last name is pasted onto column C.

Thanks,