Im trying to do a lookup and some codes but I only need the 5 digit numbers. Is there a quick way to eliminate the letters on the end of the codes?
15830P
19325
19325M
19325SE
19325S
19325SM
19325SS
19318
19316S
19316MI
19316M
Last edited by day92; 06-30-2011 at 04:04 PM.
One way...
http://www.excelforum.com/2554988-post2.html
Edit: I guess my eyes decieved me, I thought I saw more than five numbers
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
You can reference the 5 digits with formula/function: =LEFT(A1,5)
If you want an actual numeric result, then add +0 to the end.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Got it. Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks