Excel Forum
Similar Content
TRIM - Remove Spaces From the Sides of Text and Extra Ones in the Middle in Excel
Tutorial: This allows you to make sure that there are no hidden spaces at the start or end of the te...
Complete Guide to Printing in Excel Macros - PrintOut Method in Excel
Macro: This free Excel macro illustrates all of the possible parameters and arguments that yo...
Round Numbers Up or Down in Excel
Tutorial: How to round a number up or down and also to a specified number of decimal places in Excel...

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".

Got a Question? Ask it Here in the Forum.