I need a single function or a macro that can pull out a number from a cell, when the cell can be written in 1 of 2 formats: # of # GB used (x%) or # GB of # GB used (x%). I need the 2nd #. Both numbers are variable length, both before and after the decimal, the letters GB can also be written as MB or KB, and I am having trouble getting text to columns to work via the macro.
or