Forum Discussion
Solved
Excel - problems converting string containing numbers and text to a number
Hi, I have a spreadsheet containing hundreds of rows with a column formatted as general which contain numbers and text, e.g. 1.45 TB, 276 GB etc. therefore preventing any math operations (sum, avg., ...
https://docs.google.com/spreadsheets/d/12fXmWMhAtQTdB0dGBH2qYLiX4DtwSKcP/edit?usp=sharing&ouid=114266295912851354557&rtpof=true&sd=true
Glad I could help Colin59
I suspect there was no formula issue since the beginning
As you've observed this site is very EN-US driven. So, when someone post a formula the delimiter(s) inside that formula is the comma (,)
No idea what your usual formula delimiter is but let suppose it's the semi-colon (;). In such case when you're proposed something like:
=SUBSTITUTE(A2, " ", "")you should replace the 2 commas with 2 semi-columns:
=SUBSTITUTE(A2; " "; "")before trying to enter/validate the formula
- That works fine. Many thanks for the effort.