I have used mid formula in excel 2003 to extract text from another excel cell. I now want to use the resultant value in a lookup formula  how do i get the lookup formula to use the Value derievd from the previous formula. at the moment it doesn't seem to be able to.
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
migrated from stackoverflow.com Dec 10 '09 at 17:00This question came from our site for professional and enthusiast programmers. 


Mid extracts text, you must convert it to a number, try



Is the result a number? If so, use the Value function: Value(Mid(A1, 3, 5)) 


Hi guys i found out i was out by one characther on the mid formula and so was adding a space in front of the file reference so it actually is working now with no need for further adjustments  thanks for your time anyway.... 


If you're working with a lot of data, after doing the Mid calculations in one column, you could create a new column and do a paste special to paste only the values into the new column. 

