I'm trying to flop names in a cell from First Last to Last, First

This is if info is in A1 and there is a space between first and last
=RIGHT(A1,FIND(" ",A1))& ", "&LEFT(A1,FIND(" ",A1))

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Todd Taylor" <Todd wrote in message
...
I'm trying to flop names in a cell from First Last to Last, First

Make sure you have some empty columns to the right of it, then highlight the
column
Data-Text to Columns
(I assume it's first name (space) last name)
select Delimited, checkmark next to space
Finish
( I assume the names were in column A)
then, go to column C
cell C2:
=B2&", "&A2



"Todd Taylor" wrote:

I'm trying to flop names in a cell from First Last to Last, First

Thanks Sean.....I knew It had to be easy....

"Sean Timmons" wrote:

Make sure you have some empty columns to the right of it, then highlight the
column
Data-Text to Columns
(I assume it's first name (space) last name)
select Delimited, checkmark next to space
Finish
( I assume the names were in column A)
then, go to column C
cell C2:
=B2&", "&A2



"Todd Taylor" wrote:

I'm trying to flop names in a cell from First Last to Last, First