I'd like to scan a column C, with text, for a certain string that begins with "B0" folowed by 4 digits and put the found string (e.g. "B01574") in the adjacent cell, each time it finds the string. In this case, "B01574"
The string can be anywhere in the text.
The formula =If(ISERROR(SEARCH("B0****",C1,1)),"","B0****") is not working, when a B0 string is found, the result is B0****
Thanks for the help