scottwiebe
New Member
- Joined
- Nov 9, 2018
- Messages
- 8
I already read the other thread with the same name, but this still isn't working for me.
I have a column of data where each cell has 2 lines. I want to split these lines into the next column using the the text-to-columns feature. When I set a delimiter of other and enter ctrl+J, the preview doesn't change at all and when I follow through with it, the data has not been split up.
I thought maybe it was my formatting so to test, I made a new column and put the numbers 1, 2, 3, 4 all in separate lines using alt+enter. When I went to perform the text-to-columns it worked exactly how it should. I compared my previous data to this test data and couldn't find any difference in formatting. I even copied my test cell and pasted formatting on the original data, but to no avail.
What am I missing?
I have a column of data where each cell has 2 lines. I want to split these lines into the next column using the the text-to-columns feature. When I set a delimiter of other and enter ctrl+J, the preview doesn't change at all and when I follow through with it, the data has not been split up.
I thought maybe it was my formatting so to test, I made a new column and put the numbers 1, 2, 3, 4 all in separate lines using alt+enter. When I went to perform the text-to-columns it worked exactly how it should. I compared my previous data to this test data and couldn't find any difference in formatting. I even copied my test cell and pasted formatting on the original data, but to no avail.
What am I missing?