I am importing a table and some of them will have data entered as so:
1234
7989
4444
when imported, it shows in the excel cell as 123479894444
And they are not always 4 in length so I can't make that assumption. I was using the clean worksheetfunction and I thought it was stripping out the 'enters' so I removed that but it's still put in one continuous string.
I was curious and manually copying and pasting the table from word to excel ends up with the 3 values occupying three separate cells and the remainder of the row with merged cells which I don't want.
I want it to occupy one cell with a enter (alt enter in excel) placed after each value. Is that possible?
1234
7989
4444
when imported, it shows in the excel cell as 123479894444
And they are not always 4 in length so I can't make that assumption. I was using the clean worksheetfunction and I thought it was stripping out the 'enters' so I removed that but it's still put in one continuous string.
I was curious and manually copying and pasting the table from word to excel ends up with the 3 values occupying three separate cells and the remainder of the row with merged cells which I don't want.
I want it to occupy one cell with a enter (alt enter in excel) placed after each value. Is that possible?
