How Can We Merge / Concatenate data from Multiple cells to single cell

Ashu K

unread,

Jul 7, 2015, 11:32:08 AM7/7/15

to Excel...@googlegroups.com

Dear Group Members,

I have data in A column like :

Apple

Bat

Cat

Dog

I want output in B column Like :

Apple,Apple,Apple,Apple

Bat,Bat

Cat,Cat,Cat

Dog,Dog,Dog,Dog,Dog

Please Help.

Regards

Ashu Kenith

Ashish Kumar

unread,

Jul 8, 2015, 12:35:20 AM7/8/15

to Excel...@googlegroups.com

Dear Ashu,

PFA

Regards

Ashish Kumar

For Ashu.xlsx

Ashu K

unread,

Jul 8, 2015, 12:48:32 PM7/8/15

to Excel...@googlegroups.com

Dear Ashish,

Thanks a lot. I want this only.

Thanks & Regards

Ashu Kenith

Ashish Kumar

unread,

Jul 8, 2015, 11:21:55 PM7/8/15

to Excel...@googlegroups.com

Dear Ashu,

Welcome.

Regards

Ashish Kumar

Vaibhav Joshi

unread,

Jul 9, 2015, 4:23:55 AM7/9/15

to Ashu K, Excel VBA Lab

Ashish Kumar, great solution..

--
www.ExcelVbaLab.com
---
You received this message because you are subscribed to the Google Groups "Excel VBA Lab" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ExcelVbaLab...@googlegroups.com.
To post to this group, send email to Excel...@googlegroups.com.
Visit this group at http://groups.google.com/group/ExcelVbaLab.
To view this discussion on the web visit https://groups.google.com/d/msgid/ExcelVbaLab/f5593900-97bb-449b-a9c9-dfded186f910%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Ashish Kumar

unread,

Jul 9, 2015, 4:25:12 AM7/9/15

to Vaibhav Joshi, Excel VBA Lab

Thankyou vaibhav Sir.

Reply all

Reply to author

Forward