I export from a data base and the way it shows up in excel is "' 5: 0", the only info I need is the number 5, which represent the number of jobs assigned to a tech. How can extract the number 5 from "'5: 0"? Even if it is extracted to another cell that's fine.
If the data is consistent, then try:
=MID(A1,FIND("'",A1)+1,FIND(":",A1)-1-FIND("'",A1))+0
where A1 houses first string. Change if required and copy formula down.
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.
You could try Data/Text to Columns, and specify the colon as the delimiter.
I tried NVBC's tip and that would only return a #value! error. I did change A1 to the cell I was working with.
Not sure what gjcase was refering to. I'm a bit of a novise, could you please expand on your idea some more.
Thanks.
I researched the MID function and a simple MID function worked fine because all my data had a standard format. Thanks for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks