Hi all, I have a column of formula's which give results for a search but need to simplify a formula to get it to extract the numbers within the result and multiply them all.

One of the results is:

[AWA 3x1x4x1x2]

and I need to get rid of the first part [AWA] to then get a result of the rest.

This would give me ? number then I could multiply it by an additional number.

The result is not always the same, the result could be:

[AWA 3x1x2] or [SWA 2x1x4] etc etc.

Thanks for any help.