You can just insert a line feed character at the point where you want
the text to wrap. Here's an example:

Sheet1.Range("A3").Value = _
Sheet1.Range("A1").Value & vbLf & _
Sheet1.Range("A2").Value

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"sa3214 @eclipse.co.uk" <sa3214<REMOVE wrote in message
...
I wish to concatenate two cells containing text but include a CRLF between
the two parts of the result ... to give the same effect as using ALT
+Enter
when entering the data directly.

If is this possible using vba ?
If so how is it achieved ?

Regards and TIA