Getting numbers out of text string

Hi James

Thanks for getting in touch. I've looked at formulas that can attempt this but the downside is Excel's only function capable of doing this looks at the cell character by character. This makes the resulting function enormously convoluted.

There are two other possibilities: if you know any VBA then that's much better suited to this kind of work with the ISNUMERIC function.

Alternatively within Excel you can look at the Text To Columns feature on the Data menu. If the strings are in a similar pattern to the ones you've specified in your example, then Text to Columns can break them up at say, the # symbol, or after the third character. Your data might not be as regular as that but it would be a start.

I hope this helps.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector