I inherited a database which lists our products in column a and their respective specification ranges in columns b thru g. The format that the specs were entered in was 45-60.
What I want is a formula to pull out 45 as a number and separately 60 as a number.
Thanks in advance.
To extract 45: =LEFT(A1,FIND("-",A1)-1)+0 where A1 houses original code
To extract 60: =SUBSTITUTE(A1,B1&"-","")+0 where B1 has above formula.
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.
cool,
there is the rare occassion that the spec is >12 or perhaps < 20. would I use the same method?
Yup... just replace the "-" symbol in the formulas with the symbol that separates the numbers.
Thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks