formula to switch last/first name around?
Here's another one:
=MID(A1&" "&A1,FIND(",",A1)+2,LEN(A1)-1)
--
Biff
Microsoft Excel MVP
"Stilla" wrote in message
...
Is there a formula I can copy into say, cell B1, that will change a name
in
cell A1 from "Brown, John" to John Brown?
Thanks to all you excel wizards out there!
|