Spliting Full Names into Cells

  • Thread starter Thread starter Nada
  • Start date Start date
N

Nada

If I have the following name:

Nada Jamal Ahsan

and i wanna split the first middle and last names into 3 differen
cells? is it possible? what dp i do when there are 4 names in a singl
cell?

HELP!!
 
Try

Data/Text to Columns.../Delimited and check the Space checkbox in
the second pane of the Text to Columns dialog.
 
Back
Top