Column Concatenate

[sathishkm]

Hi All,

I have two columns comp and add. Here i need to concatenate these columns in C. The data may vary randomly. It may increase or decrease. Is there a formula or a vba

Comp Add Need
23 and Me 615 John Muir Dr 23 and Me615 John Muir Dr
23 and Me 1601 Ygnacio Valley Rd 23 and Me1601 Ygnacio Valley Rd
23 and Me 1601 Ygnacio Valley Rd 23 and Me1601 Ygnacio Valley Rd
23 and Me 1601 Ygnacio Valley Rd 23 and Me1601 Ygnacio Valley Rd
23 and Me 1601 Ygnacio Valley Rd 23 and Me1601 Ygnacio Valley Rd
23 and Me 1601 Ygnacio Valley Rd 23 and Me1601 Ygnacio Valley Rd
23 and Me 915 San Ramon Valley Blvd 23 and Me915 San Ramon Valley Blvd
23 and Me 1601 Ygnacio Valley Rd 23 and Me1601 Ygnacio Valley Rd
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct
ABC 1333 Broadway, #603 ABC1333 Broadway, #603
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct
ABC 47102 Mission Falls Ct ABC47102 Mission Falls Ct

[PCI]

See the use of & like = A1 & B1
or the use of CONCAT(A1,B1)

[Phlegon_of_Tralles]

Can you upload a spreadsheet? I think PCI's post covers it, but I have a suspicion that you might be asking for something more than just a concatenation.

[sathishkm]

Please check the attachment

[PCI]

D2 =a2 & b2

[sathishkm]

How it can be done randomly. The same task how it can be done for N rows.

[PCI]

You just need to copy the formula and paste it down to the last row
What do you mean randomly, can you give an example of the final result ?

[PCI]

I have the feeling you want a macro, see after

Please Login or Register  to view this content.

[sathishkm]

I need to write the formula each time to do this. This is my repetitive tasks. Every time I have to concatenate two columns. So I need to find some alternate way to do just like if to concatenate each columns randomly. Example if i have only ten rows, ten rows need to concatenate. If i have 100 rows, 100 rows need to concatenate randomly.

[sathishkm]

This is what I need. Thanks

[sathishkm]

It is not executing if the rows are having more than millions