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

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

Home › Other Content › Excel Magic Trick 715: Take Number with Spaces and Convert to Number
Sources from excelisfun, • Youtube on Youtube • Published 15 years ago
ChannelPublish DateThumbnail & View CountActions
Channel Avatar excelisfun2010-09-09 19:28:52 Thumbnail
214,230 Views
View on YouTube View Channel
Download Excel Start File https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT715-721.xlsx

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/

Please take the opportunity to connect and share this video with your friends and family if you find it useful.