How do I convert math abbreviations to integers?

I have a data set that uses shorthand such as 10K, 2.5M, 3.4K etc. to represent large integers.
How do I create a formula for converting them to whole integers?

Find & replace is dumb and will take too long.

Where is your “data set”? Is it a table in Base or a spreadsheet or a file? And what is the target of the transformed data? The tag “math” seems wrong to me, because the “Math”-module is for typesetting formulas.