Excel help (please!)

ssmacc · 5 Feb 2010 at 11:10

Hello,

I need some Excel help! I have a spreadsheet with 4 lines of an address in columns

House # Street Town Etc.

I'd like to merge these into one cell, and one below the other (standard address):

House #
Street
Town
Etc.

I’m sure there is an easy way to do this but I can’t find it.

Can anyone help?

Cheers

wozencl · 5 Feb 2010 at 11:28

=A1 & CHAR(10) & A2 & CHAR(10) & A3 & CHAR(10) & A4

Replace A1 etc. with your cells.

Note: The target must have text wrapping enabled or you will get a symbol instead of the newline.

rhysduck · 5 Feb 2010 at 11:29

Beat me to it

ssmacc · 5 Feb 2010 at 11:46

Thanks, i need to change it a little bit as i wanted to pick cells accrss not down, but i couldn't have done it without you!

=D4 & CHAR(10) & E4 & CHAR(10) & F4 & CHAR(10) & H4 & CHAR(10) & I4 & CHAR(10) & J4

Cheers

EDIT
Just read the note part again and appreciate that I’ve pointed out exactly what you said...must stop drinking on Thursdays!