I need help with removing text and only showing numbers

Hey guys, I would like to thank you in advance for any help received.

OK, so here is my problem, I have a bunch of text and numbers in a cell, when I reference that cell through another one I don't want to show the lettering as that is screwing with the rest of my sheet.
I have worked out how to remove the text that is before the numbers that I want, but I cannot work out how to remove the lettering that is proceeding the numbers that I need.

Example: Median selling price in view: 4,999.06 ISK

This code: "=RIGHT(Sheet2!C5,LEN(Sheet2!C5)-30)"
makes the line show "4,999.06 ISK"

I tried to add a "-FIND("isk",LEN(Sheet2!C5))"
to fix my problem, unfortunately that didn't work for me just comes up with the "#VALUE!" error.

In case it helps, I have imported text from a website using the "get external data from a website" command, this text cannot be changed.

How look your number with zero's in decimal places:

1,234.00 or 1,234?

would i be able to tack that onto the end of the "right" function somehow?
I tried just the "left" function that you posted and it showed all the text and numbers... im probably doing something wrong

yes the text, back and front will always be the same, the numbers will change in length constantly.

Originally Posted by benishiryo

hi Mina, try this:

=LEFT(RIGHT(Sheet2!C5,LEN(Sheet2!C5)-30),LEN(RIGHT(Sheet2!C5,LEN(Sheet2!C5)-30))-3)

but is your number of texts in front & the back always the same?

this worked perfectly, thank you so much... been trying to figure this out for hours.