Formula to Ignore Text in a Cell with Numbers

[carwinski]

Hey guys,

Looking for some assistance.


- My "Importing" file is attempting to reference data downloaded in to "Importing" file cells from a website.
-The number data on the "Importing" file downloads from a website in this "#### FH" format.
-I'd like my "Importing" sheet to ignore the text that is next to the number data in the "Importing" cells so that I don't get a *VALUE error where there should be a result.

Any ideas?

I feel like its an easy fix but my Excel level isn't there!

Thank you in advance!

[Fluff13]

How about
=LEFT(C2,FIND(" ",C2))-B5

[Richard Buttrey]

Hi,

One way

Please Login or Register  to view this content.