Data Arrangement
1 way.
select the column of names and then click data- text to columns. It's pretty
intuative what you go next and you will end up with the names in 3 columns.
You can then concatenate then back into 1 column in the order you want using
=concatenate(A2,A1,A3)
and then delete the 3 columns you created.
Mike
"Port Man" wrote:
I have text in a cell that is in the format:
LastName FirstName MiddleName (ex. Willson James Nichols).
Is there a way to switch the text to:
FirstName MiddleName LastName (ex. James Nichols Willson)?
Thanks.
--
|