Text to Columns on Data Entered Using ALT+ENTER

What I am going to report may have been known by all Excel users except me since the dawn of time. I suspect not. If I am teaching everyone how to suck eggs I apologise but hopefully, someone will find it useful.

I was given a spreadsheet with multiple lines in cells that had been created using ALT+ENTER. I needed to use Text to Columns to split each line into separate cells. I couldn't work out what character to use in the Text to Columns, Delimited, Other field.

I created a test spreadsheet and viewed it with a hex editor (ZTreeWin) and saw that the ALT+ENTER character was hex 0A or decimal 10.

Using the numeric keypad I entered ALT+010 in the Other field. The multiple lines were then parsed as required.

Andrew Watson