What's the easiest way to take columns of cells with a number followed by a space and then text, and switch the order to text/space/number? (my columns look like this "8 piscataway", "14 dayton", "42 mason", and I'd like them to read "piscataway 8" etc). TIA!
Last edited by maryjdelo; 09-02-2009 at 02:05 PM.
Try in an adjacent column:
=MID(A1,FIND(" ",A1)+1,100)&" "&LEFT(A1,FIND(" ",A1))
copied down.. where A1 contains first item.
Then copy entire column and paste special | values over the original.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Ok, when I paste the formula into the adjacent column it works, but when I try copying that column and pasting it over the original, both columns fill with "#REF!"...
Copy the cell(s)
Select the original cell(s)
Select Edit > PasteSpecial > Values
Delete the added cells
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
You have to do a special paste...
so after copying, go to original column and then Edit|Paste Special.. then select Values.
Click Ok..
Now you should be able to delete the formula column.
Thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks