Extracting numbers from text?

Originally Posted by shiftyspina

I have tried both and neither work, on my sheet, it may be that i have simplified the data im trying to extract the number from

That's why you should post examples of the REAL data. If it contains sensitive or confidential info then you can "disguise" that portion of the data.