We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Splitting cells down in excel
Comments
-
Quite right captain Kirk. What really is the point of Zola's post?0
-
Ive done the text to columns approach with a certain amount of success.
Will check out the YT video later. Ive tried setting the delimiters (in the text to column box) to tabs, but it doesnt appear to effect the cell in any way.
Thanks.0 -
That will be because once the data record is in the single cell there are no longer any tabs -during the loading process of the file the tabs are effectively stripped out. Using the text to columns function you need to use whatever is then in the cell (you are left with those characters you identified in your earlier post and not by then any tabs)0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.6K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178.1K Life & Family
- 260.6K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards