removing line space

good morning everyone
any help would be glad appreciated for the following small issue (i'm quite a non excel person but trying hard to improve )

I have a very long listing on excel (initially downloaded via a csv file). in the column B, I have address. The way they are from the downloaded file is that all the parts of the address are on different lines. My aim is to have the whole address in only one line. Of course, if I take cells one by one I know how to correct that but the issue is that the listings are hundreds of lines long. Is there any way to do it for all the B cells at once?

excel 1.PNG

thanks a lot for the help

Click on the column identifier for column B to select the whole column, then do Ctrl-H to pull up the Find & Replace dialogue box, and then enter the following:

Find what: Ctrl-J
Replace with: comma space
Click Replace All.

Hope this helps.

Pete

dear Pete
thanks a lot for your help it did work. I tried many times yesterday to fix the problem with the Find and Replace option but I clearly did not have the right inputs!!. now i kinda have comas everywhere but it absolutely is no big deal , i can handle that!!!

thanks again! much appreciated