--Select the range/column needs to be changed. From menu DataText to Columns
will populate the 'Convert Text to Columns Wizard'
--By default the selection is 'Delimited'.Keep the selection and hit 'Next'.
--From the Step2 of the Wizard from the options select Space
--Hit Finish

If this post helps click Yes
---------------
Jacob Skaria


"Μανολης Β" wrote:

I have an excel list with 300 names. Each name and surname are both written
to the same cell (eg. "George Smith"). However i want name and surname be in
2 different cells. Is there any function or command that i can aply and solve
my problem??
I think that this command can recognize the gap between the 2 words and then
divide the text into 2 cells insead of 1 or cut and paste a part of the text
to an other cell.

thanks a lot
Manolis