Thread
:
EXCEL FORMULAS
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Harker
external usenet poster
Posts: 162
EXCEL FORMULAS
Hi Michael!
One way is to set up a new column and use the formula:
=RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,FIND(" ",A1)-1)
Then use Copy Paste Special Values on the new column and delete
the old one.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"MICHAEL KENT" wrote in message
...
This might be an incredibly easy solution to my problem,
but I cannot think of it !!
I have a list of employees which is set out in the format
of first name, then surname e.g. John Smith.
I want to turn that around to read Smith John - is there a
way of doing this ??
Thanks !!
Reply With Quote
Norman Harker
View Public Profile
Find all posts by Norman Harker