Line break formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I need to combine two cells into one - which I can do using the ampersand
formula, however I need to insert a line break between the information in the
two cells. Would someone please be able to point me in the right direction as
to how I would do this?

Many thanks,
Catriona
 
Try something like this:

B1: =A1&CHAR(10)&A2

That formula appends the value in A2 to the value in A1, separated by a
carriage return......(that's what ASCII character 10 is)

Remember to set the cell format to wrap text and adjust the column width if
you need to.

Does that help?
***********
Regards,
Ron

XL2003, WinXP
 
Back
Top