Right... it may be surprising to you, but I already searched excel's help before posting.
And as far as what I want to retrieve - everytime "J6R" appears within a string in a cell, I want to return "J6R" in another cell. So the first cell that I am searching may have "asdfalsdf J6R asdfasdf". The function in the second cell should search the string for J6R, and if it finds it, return "J6R". If not, return nothing. I am not trying to find the position of the text.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.