Excel Forum
Similar Content
Guide to Referencing Other Excel Files with Formulas and Functions
Tutorial: Your guide to making cross-workbook formulas and functions. This includes an overview of p...
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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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
4.
Download file: http://people.highline.edu/mgirvin/





Got a Question? Ask it Here in the Forum.