Excel Magic Trick 715: Take Number with Spaces and Convert to Number

Download Excel Start File https://people.highline.edu/mgirvin/Y...

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/

• #science_technology
• #excel
• #2007
• #2010
• #take
• #number
• #with
• #spaces
• #and
• #convert
• #to
• #substitue
• #function
• #plus
• #zero
• #mike
• #gel
• #girvin
• #highline
• #community
• #college
• #slaying
• #dragons
• #keyboard
• #shortcut
• #for
• #text
• #to
• #column