I have some Excel files containing cells with values like "20 mA", "3.13 µA" , "1.66 mV" and similar.
Would it be possible to somehow ignore the last character ('A' or 'V') and then multiply the number with the suffix automatically?
For example 20 mA should result in 0.02