concatenat new line

[oafum]

Folks,

I am trying to concatenate several fields into a single text typ
field. for example

Notes:
4/25 This happened
4/26 That happened
4/27 And now this.

When concatenated they appear like this:

4/26 This happened 4/26 That happened 4/27 And now this.

I want it to look like this...

4/25 This happened
4/26 That happened
4/27 And now this.

How? The vbnewline won't work and neither does chr(10

 

[Dave Peterson]

=a1&char(10)&a2&char(10)&a3

Remember to use format|cells|alignment tab to turn wrap text on.