Need to separate and rearrange names
This works. Thanks.
"Rick Rothstein" wrote:
Actually, if your data could be mixed (some with a space after the comma and
some without one), then you can use this formula to handle both of those
conditions...
=TRIM(MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1)))
--
Rick (MVP - Excel)
"Rick Rothstein" wrote in message
...
Assuming there is no space following the comma (both your examples show
that), give this formula a try...
=MID(A1&" "&A1,FIND(",",A1)+1,LEN(A1))
--
Rick (MVP - Excel)
"Nadine" wrote in message
...
How do you take Last,First and change it to First Last?
Ex: Joe,John needs to be rewritten to John Doe.
Using Excel 2003 and having the formula be in a different cell than the
text
it is converting so that the original text remains unchanged.
.
|