Data Arrangement
 

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.
--

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.
--