Concatenate each cell in column A with Colulmn B and C

**james19** · 03-11-2015, 05:34 AM

Hi,

I'm trying to make something that will concatenate each cell in column A with each cell in column B and C untill it finds a space. It's part of a personal 'first VBA' project that I'm doing so it would be great if it was in VBA for me to tinker with. Can someone help me do this please? I've attached an example.

Thanks

**p24leclerc** · 03-11-2015, 07:45 PM

You can try this macro which will work for the first part only. You'll see where it will stop.
It's, at least, a start for you to work with.

Please Login or Register  to view this content.

**james19** · 03-17-2015, 03:04 PM

Hi p24leclerc,

Sorry for the late response. Thanks for this, it gives me something to start playing around with :-).

**james19** · 03-17-2015, 03:04 PM

Hi p24leclerc,

Sorry for the late response. Thanks for this, it gives me something to start playing around with :-).

Concatenate each cell in column A with Colulmn B and C

LinkBack

Thread Tools

Rate This Thread

Display

Concatenate each cell in column A with Colulmn B and C

Re: Concatenate each cell in column A with Colulmn B and C

Re: Concatenate each cell in column A with Colulmn B and C

Re: Concatenate each cell in column A with Colulmn B and C

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenate a Column into one cell with a , between values

[SOLVED] Help Concatenate All Cells In A Column To A Single Cell In Another Column

Concatenate a Column Range To a Cell

Concatenate a Column into one Cell

Excel 2007 : Concatenate Next Non-Empty Cell in a Column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions