I have a column of numbers where some of them are 1.92M as an example so I need to multiply those cells where the “M” shows up by replacing the “M” with *1000000. Can you tell me how to do this?

Thanks in advance.

I have a column of numbers where some of them are 1.92M as an example so I need to multiply those cells where the “M” shows up by replacing the “M” with *1000000. Can you tell me how to do this?

Thanks in advance.

Here, how you do it (I took the liberty to add K for thousand and B for billion)

Transform file.

TransformOrReplaceNumbers.transform (3.1 KB)

2 Likes

Thank you for the quick response!