It works once I formatted my column as text. A thousand thanks...

"B. R.Ramachandran" wrote:

Hi VDan,

I did test the formula before posting my earliner reply.
"Microsoft Excel" in A1 does transform into "Excel, Microsoft".

Maybe, there is a formatting problem in the spreadsheet. Format them as
Text and see whether it helps.

B. R. Ramachandran



"VDan" wrote:

Perhaps my original question was unclear.
In cell A1 the name as currently written is Microsoft Excel. I need to have
the name as Excel, Microsoft.
I have tried the suggested formulas but keep getting the #VALUE! error.

"B. R.Ramachandran" wrote:

Hi,

For a name in A1, try this formula in B1 (or C1, D1, ...)

=RIGHT(A1,LEN(A1)-FIND(" ",A1))&", "&LEFT(A1,FIND(" ",A1)-1)

The formula should work if there are no spaces within the firstname.

Regards,
B. R. Ramachandran


"VDan" wrote:

Hi,
I have a list of names in excel that is currently listed Firstname Lastname.
I need it to be listed Lastname, Firstname.
Is there a way to do this?