Excel Forum
Similar Content
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...
Reference Other Excel Files with Formulas and Functions
Tutorial: In Excel you can use formulas and functions to reference data that is stored in another Ex...
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 715: Take Number with Spaces and Convert to Number

See how to:
1. Take a number with spaces, remove spaces and convert text to number using the SUBSTITUE function and plus zero
2. Take a number with spaces and separate the numbers into individual cells using Text To Column.
3. Keyboard shortcut for Text To Column: Alt + D + E + F or Alt + A + E + F
Download file: http://people.highline.edu/mgirvin/

Got a Question? Ask it Here in the Forum.