Line break formula
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
"Cat" wrote:
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
|