Concatenate - help

Thanks a lot anil,
I am trying to use the formula.. i am newbie to excel vba.. I will play with it for some time now and get back to you on that.. just to make one this sure.. I can just use this formula and select the range everytime i wanna concateneate a bunch of cells right?.. Thanks a lot again

I can just use this formula and select the range everytime i wanna concateneate a bunch of cells right?

Yes that is correct.


Let me know if you have any questions

Hey Anil
That is great.. it works beautifully.. Only thing is could you tell me how I can add code to format it? I am adding a bunch of lines and I want them to be wrapped so they all the lines i added wont be

In what format do you want.

Anil,
I just want to make sure the when I add all that string they appear clearly in that one cell. I want all the text to appear in the cell and also I dont want them to be bunched into one line. As I am adding many lines from different cells I want them to appear line by line in the same cell. Please let me know. Thank you.

pralav

Function concat_range(r As Range)

Dim val As Variant
Dim c As Range

For Each c In r
val = val & c.Value & Chr(10)

Next

concat_range = val


End Function