Truncate last two char on non fixed length cell

[brusk]

I have one sheet with a bunch of DB sizes currently given in the format of size space GB (1,000 GB) but to use them in a few of the formulas I have I need just the number. How to do drop the part after the number and given this might be say 10GB, 100 ro 1,000. Also need to figure out how to drop the comma.

Thanks,
Bruce

[Ron Coderre]

With
A1 containing a number followed by text...
Examples:
1000 GB
1,000gb
100MB

This formula returns the numeric portion of that text:

Please Login or Register  to view this content.

Using the above examples, that formula returns:
1000
1000
100

Is that something you can work with?

[brusk]

That is awesome. Works perfect. Can't say I exactly understand what it's doing though.

[mwemett]

I have to import an Excel list into a marketing automation tool and it does not allow for blank spaces in ANY cell. Is there a function that I can apply to the entire spreadsheet that will delete any non-character spaces?

[DonkeyOte]

mwemett, welcome to the board however please note:

Your post does not comply with Rule 2 of our Forum RULES.

Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.