You know how to remove the order in Excel
Artillery Tower 1
Fleet Assault 2
Asteroid War 3
Asteroids Revenge 4
Astroblaster 5
Astroflash 6
The order is the last number on the right, so the result is
Artillery Tower
Assault Fleet
Asteroid War
Asteroids Revenge
Astroblaster
Astroflash
Thank you very much!
Assuming that list is in column A, but this formula in B1 and copy down (or any empty column):
=TRIM(LEFT(A1,FIND("^", SUBSTITUTE(A1, " ", "^", LEN(A1)-LEN(SUBSTITUTE(A1," ",""))))))
Then copy the resulting list in column B and do an Edit > Paste Special > Values over the old values in column A to make them permanent.
_________________
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!)
Thank you so much!
If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks