Merging Cells adding Carriage Returns

[Colin Vicary]

Hi everyone

I've been sent a text file to import that contains (amongst othe
things) addresses.

These addresses are split over 5 cells and I want to merge them al
into one cell per address so I used :-

=B2&""&B3&""&B4&""&B5&""&B6

This worked great, but turned the address into a sinlge line. I reall
want to add carriage returns at the end of each line to make it mor
readable.

Any ideas please?

Thanks

Coli

 

[Andy Brown]

This worked great, but turned the address into a sinlge line. I really

want to add carriage returns at the end of each line to make it more
readable.

Use

=B2&CHAR(10)&B3&CHAR(10)&B4

, etc. You'll need to format cell alignment (CTRL+1) as Wrap Text, most
likely.

Rgds,
Andy

 

[Colin Vicary]

Andy

That worked perfectly, thank you!

Do you know where I can see a list of all the special characters like
line feeds and so on?

Thanks

Colin

 

[Andy Brown]

Do you know where I can see a list of all the special characters like

line feeds and so on?

Not sure about "see". If you enter =CHAR(ROW()) in A1 & drag it down to
A255, it'll give you the list of ALT+0000 codes.

Chip Pearson's Symbolizer add-in may be of interest,
http://www.cpearson.com/excel/chars.htm

Rgds,
Andy