How to divide the text data into two cells

[Oleg]

How to divide the text data ???
e.g. In a cell A1 entered name & surname. I want to divide
the data into two cells, name into cell B1 and surname
into cell C1.
A B C
1 John Smith John Smith
2 Andrew Stewarts Andrew Stewarts
3

 

[Paul]

How to divide the text data ???
e.g. In a cell A1 entered name & surname. I want to divide
the data into two cells, name into cell B1 and surname
into cell C1.
A B C
1 John Smith John Smith
2 Andrew Stewarts Andrew Stewarts
3
4

Assuming there are just two words in A1 separated by a space, these formulas
in B1 and C1 will separate the two words:
=LEFT(A1,FIND(" ",A1)-1)
=RIGHT(A1,LEN(A1)-FIND(" ",A1))

Copy down columns B and C as far as required.

 

[Tina]

if I understand it right you want that column A (with name & surname) gets
split into column B (name) and column C (surname)....

mark column A with all the names in....then go

Data --> Text to Column ---> click on fixed width ---> next ---> next --->
change Destination to column B ---> click finish

now you should still have the name and surname in column A and in B you
should only have the name and in C the surname