Help with names and addresses list - transposing and formating

[theanimallover]

I need some help. I've copied 100's of names and addresses from google spreadsheets to excel. They don't copy over very well, there are a lot of 'hidden' bits. The names and addresses are all over the place, some you have to click on the cell to retrieve the info as a new line has been created.
So... I used paste special, then match destination formatting. This did the trick but left small squares at the end of each row (where I guess the new line/paragraph would have been...) so how do I get rid of the squares?

Secondly, the names and address look like this each line of the address is in a seperate cell:

Bruce Butler
17 The Cottage
Anywhere
HA4 7TT

I need them to read across the page like this, with each line in a new cell:

Bruce Butler 17 The Cottage Anywhere HA4 7TT

I know you can 'transpose' but that only works individually, how do I transpose the whole sheet, I have many sheets with hundereds of names and addresses.

Phew I'll be a very happy girl when this is sorted, thanks in advance for your help.

[arthurbr]

Hi

This did the trick but left small squares at the end of each row (where I guess the new line/paragraph would have been...) so how do I get rid of the squares?

You will find a complete solution at this page

Secondly, the names and address look like this each line of the address is in a separate cell:

Have a look at this solution
http://www.cpearson.com/Excel/Variab...mnToTable.aspx