[RESOLVED] How to show multiple lines string using formula

Sir,

I m trying to insert a string which is in multiple lines. Is there any keyword in CR equivalent to [vbcrlf] for showing other string to next line.

Regards,
Manish

I got the solution. I used [chr(13)] function to enforce string to next line.
Thanx

chr(13) by itself does not perform the vbCrLf. you need to use

Code:

---

chr(10) & chr(13)

---

in conjunction for proper result