I have a spreadsheet of data that was sent to me in Excel 97-2003.
One column of address data contains multiple fields that I need to split into separate columns. The data in each cell that I need to separate is separated by a paragraph / return which shows as a question mark in a box symbol. When using "Text to columns" I can't get excel to recognize these marks or a return.
This is an example of some data in one cell, the question mark in the box does not show when I copy and paste.
'28 MURIAL STREET
If I convert text to column using either space or tab, it only converts the first line of text. Ideally I need three columns with the data from each line in each.
I hope this makes sense and that you can help!