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.*

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.