Forum Discussion
Solved
Extracting specific text/number combo
I am trying to pull out specific information from a list of cells that do not always have the same amount of characters surrounding the information, but always has the same of amount of characters to...
=MID(C4,SEARCH("???/??R??",C4),9)Maybe with this formula. However there is a weak spot as you can see in the attached file if you compare the last 2 examples.
Jenna_Foy That could be
=MID(A1,FIND("/",A1)-3,9)
where A1 would contain the string you want to extract the 9 characters from.