I need help to separate 3 lines of an address contained in 1 cell please

1. Select the whole column.
2. Open Find & Replace (Home ribbon).
3. In the Find field, type CTRL+J (you will see a dot appear).
4. In the Replace field, type | (pipe symbol, usually near the left-hand SHIFT key).
5. Now use Text to Columns on the Data ribbon to separate the entries, using the | character as the delimiter.

Then you will need to attach a sample workbook.

It sounds like you are trying to remove what used to be called a carriage return. If so here is a way I used to do that...
go to find and replace, at find hit "ctrl and enter" then at paste hit the space bar once then do replace (or replace all).

Attach a workbook here, but you have marked the thread as solved ...

I now have this part of your instruction working "In the Find field, type CTRL+J (you will see a dot appear). In the Replace field, type | (pipe symbol, usually near the left-hand SHIFT key).
I couldn't get the above part working when I originally asked the question.
In my sample worksheet with the Text to columns part, I select the range of cells to convert, go through the wizard but I only get the first line of each address.

The thread is marked as solved, which is probably why you have had no help with it! Please remove the solved tag so that members know that you require further help. Thanks.

From post#8

Please try at J6 drag across and down

=TRIM(MID(SUBSTITUTE($B6,CHAR(10),REPT(" ",99)),COLUMNS($J6:J6)*99-98,99))