Text to Columns only keeps first line.

Hello, I have thousands of Addresses in a column that I need to convert to a cell each for address town state and postcode
Currently its separated by line breaks

I understand how to do it but it isnt working.
I highlighted all the cells, and went into text to columns, but even with nothing selected only the first line is exported.

Capture.PNG


Capture2.PNG


I Tried replacing the line breaks with Comma's but ticking the Comma box still didnt work
I have attached an example

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

deleted... title updated

Try

Please Login or Register  to view this content.

Or the following Amended after advice from Ben Johnson.

Please Login or Register  to view this content.

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread