Reversing String
Mike wrote on December 31, 1969 19:00 EST
This doesn't work
standinwave wrote on April 20, 2006 10:33 EST
I just removed the double quotes within the FIND function and it worked fine - like so =RIGHT(A2,LEN(A2)-FIND(",",A2)-1)&" "&LEFT(A2,FIND(",",A2)-1)
vikkam wrote on January 17, 2007 17:26 EST
How do I seperate the one string to 2 columns
Bush, George to George (column a) Bush (column b)
jasoncw wrote on January 17, 2007 17:30 EST
Data > Text to Columns, then make sure both space and comma are checked. To reverse the columns you can cut and paste.
vikkam wrote on January 17, 2007 17:32 EST
I am still confused.
can you please elaborate by giving example
daddylonglegs wrote on January 17, 2007 17:34 EST
A formula approach......
with "Bush, George" in A1 use this formula in B1
=TRIM(REPLACE(A1,1,FIND(",",A1&","),""))
and in C1
=LEFT(A1,FIND(",",A1&",")-1)
VBA Noob wrote on January 17, 2007 17:34 EST
Try
In B1
=RIGHT(A1,FIND(",",A1)+1)
and
in C1
=LEFT(A1,FIND(",",A1)-1)
Then paste special values in A1 and B1
VBA Noob
jasoncw wrote on January 17, 2007 17:35 EST
Ok, say the names are in cells A1:A10. Highlight these cells, then from the menu select Data, then Text to Columns. This will bring up the Convert Text to Columns Wizard.
Select Delimited, then click Next.
Make sure both "Space" and "Comma" check boxes are checked, then click Finish.
What this will do is put the last names in cells A1:A10 and first names in cells B1:B10. If you want them in reverse order, you can simply cut and paste the cells to where you would like them.
vikkam wrote on January 17, 2007 18:07 EST
thanks
vikkam
What if there is a middle initial?
lradon wrote on January 18, 2007 12:13 EST
How can the formula be adjusted if the name read:
Smith, Brian A.
TIA, Laura :)
jasoncw wrote on January 18, 2007 13:32 EST
[QUOTE=lradon]How can the formula be adjusted if the name read:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
Microsoft Excel Version 2002 Step by Step
