Hi,
Good day!
I have a column of figures with several units attached to it via custom format, e.g. KG, PC, G, CS, etc.
I would like to extract the units onto another column, showing only the units using formula only.
I've tried the =cell("format",XX) function but it seems to return ",0"...