Creating multiple rown in single cell from multiple columns

Hi

I need to manipulate an excel spreadsheet.

I have three columns, address1, address2, address3 and I need them to be placed into a single cell, the only complication is they need to be above one another. eg.

address1
address2
address3

Any help will be appreciated

Thanks in advance.

Thanks for the response I do appreciate it but that's still not what I need.

Unfortunately that still leaves the data in a single line, I need the equivelant of going into a cell typing the first address then alt+enter address 2 etc.

I have to import into a database program and it imports the address in that format. If it's in a single line the database will just show the single line.

Any other suggestions?

Thanks Cheeky_Charlie,

Worked perfectly up till row 40, how can I get it to do that will row 3600

Thanks so much again.

SGLife,

Just tried your option now, worked perfectly copied it across all rows and seems to be 100%

Thanks for all the help