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.
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. 

