How can a string like "17,946.91 MB" be converted to a regular number "17946.91"?

Question

excel

Of course, when adding new data through autocorrect, you can do the necessary operations, but this is not very convenient. Can this be done automatically?

Answer 1

The safest and easiest way to avoid macros is where you don't need them. We enter the initial data, for example, in column A, and in column B we write the formula
If you have a blasphemous Russian Excel, judging by the Russian decimal separator, then it will look like this:
(for cell B1, respectively, the "raw" value in A1, then stretches to the desired range)