You could do this with text formulas, but then you would have formulas in
your columns, and not just plain text.
You could try using "Text To Columns", which would yield actual text in
separate columns, without having to remove any formulas afterward.
Select your column of names, and then:
<Data> <TextToColumns>,
Make sure "Delimited" is checked, then <Next>,
Click in "Space", then <Finish>.
You should now have two columns of names.
If you have more then two columns, that means your original column of data
contained *more* then just a first and last name.
If you're not satisfied with the results of the TTC procedure, post back
with what you have displayed, and what you would *like* to have displayed.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
If have a column that has first and last names combined.
I would like to separate them and make 2 columns, one
first name and one last name. Is there formula to do this?
