Splitting data in cells
 

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,

Splitting data in cells
 

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,

Splitting data in cells
 

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,