Hello,
I have this huge column of numbers that needs to be separated into multiple columns. This would take forever to do manually. I was wondering if there was a really fast way to do this.
I've attached the file.
Hello,
I have this huge column of numbers that needs to be separated into multiple columns. This would take forever to do manually. I was wondering if there was a really fast way to do this.
I've attached the file.
Last edited by MarginofBuffett; 02-18-2011 at 03:51 PM.
Highlight A4:A370
-> Data Tab -> Text to Columns -> Delimited -> Space: ensure Treat Consecutive Delimiters as one is checked -> Finish.
Word of advice:
Upon completion of above re-run Text to Columns and in Step 2 un check Space then click Finish
(this resets TextToColumns settings - should you paste space delimited data into Excel going forward it won't split your data)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
I've never noticed that Text-to-Column button. Very handy. For some reason the steps you laid out didn't work. This is what I did: Text to Columns -> Fixed Width -> General -> Finish.
Last edited by MarginofBuffett; 02-18-2011 at 03:48 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks