|
Featured Tutorial
Featured Macro
Excel Magic Trick 772: Remove Spaces From Number and Convert To Number
Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm
See how to use the SUBSTITUTE function to remove spaces from a number stored as text and then convert the new "text" number to a number using "+0".
See how to use the SUBSTITUTE function to remove spaces from a number stored as text and then convert the new "text" number to a number using "+0".