Alan Ramsay
New Member
Hi there,
I need to be able to search the cell contents for a specific set of values and then have the matching value returned to the cell I put the search formula in, for example:
· In cell B2 I have the following string “BCO6”.
· In cell C2 I want to add a formula that will look at, (search), B2 for the following variables, “4”, “6” or “8”. It will then return the matching value, (in this case “6”), or insert a blank “” if there is no matching value.
I have been looking on the web, playing with the FIND command and SEARCH commands but they all seem to want to return the position of the variable not the variable itself. I know I could use MID, LEFT or RIGHT if the position of the variable was fixed but it is not, i.e. in my example it might be “B6OC”.
Any ideas anyone?
I need to be able to search the cell contents for a specific set of values and then have the matching value returned to the cell I put the search formula in, for example:
· In cell B2 I have the following string “BCO6”.
· In cell C2 I want to add a formula that will look at, (search), B2 for the following variables, “4”, “6” or “8”. It will then return the matching value, (in this case “6”), or insert a blank “” if there is no matching value.
I have been looking on the web, playing with the FIND command and SEARCH commands but they all seem to want to return the position of the variable not the variable itself. I know I could use MID, LEFT or RIGHT if the position of the variable was fixed but it is not, i.e. in my example it might be “B6OC”.
Any ideas anyone?