I would like to add a Powerquery approach. Translating 100k to the actual numeric value, algebraically, then, 100k is 100(k). So, now I can have logic applied intuitively which is to say 100k is two values, one hundred and k. In powerquery I split 100k using split columns:

= Table.SplitColumn(#"Changed Type", "Column1", Splitter.SplitTextByDelimiter("k", QuoteStyle.Csv), {"Column1.1", "Column1.2"}) = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", Int64.Type}, {"Column1.2", type text}}) Note by using the split function, a transformation followed. The 100k which was read in as text becomes two columns, the 100 now reads as integer and the second column is the one after the k which is a text. Part one done. Now we need to take one hundred and times it by 1,000:

Use the following powerquery (step):

[add column, custom fx] = Table.AddColumn(#"Changed Type1", "Column1New", each [Column1.1]*1000)

Colunn1New now holds 100000.

Analysis: note that these power query steps reflect common programming logic such as that found in python:

for k in string:
k = (k) return string out: 100(k) [note we would save the function as 'afunc(string)' and call it afunc(100k)] .. we would use the transform 100(k) idea by using the split function on '(' that gives two values, a number 100 and the string 'k)'. And we would then only use the one hundred value, save it to a variable and times it by 1,000 in another function or class.