I am facing problem of merging data and wrapping the text
Right now it just wraps the data however I want the text go to specific number of column and then continue on next line in the same cell



Kasim Gaya

Kasim Gaya,

To wrap test in a cell use the vbLF command (visual basic line-feed).

For instance, to place the text: "The clients are:"
                                  "(1) John Smith"
                                  "(2) Jane Doe"

To occur on different lines within a cell, you would enter:

     ActiveCell.Value = "The clients are:" & vbLf & _
                        "(1) John Smith" & vbLf & _
                        "(2) Jane Doe"

Note: The underscore is a command continuation character.

For more info recommend www.vba-programmer.com

CarlR