Hi.
I hope somebody might be able to help.
I have a spreadsheet which contains product descriptions. Some of which include some product codes which I wish to extract into a different column. I've hunted high and low and got myself in a muddle, so came here for help.
An example of a cell:
200 Sheet Probe Wipes (130 x 130mm) (B81010043)
The product code is B81010043 which is what I need to extract and place in a new cell. It will ALWAYS start with a B and it will ALWAYS be followed by 8 numbers. (So lowest code would be B10000000 and highest number would be B99999999)
Does anybody know of a way to do this with a formula ?
Many thanks in advance.
Bookmarks