Concatenate Cells for unspecified range

Hi, I am trying to take two cells and concatenate them for an unspecified range (it could be 50 cells or it could be 500) using a VBA macro.  I would like to get FrontDimension & Cup combined in the F_demension as well as BackDimension & Cup into B_Dimension.  My sample data is below.  Thanks for all your help in advance!

FrontSize FrontDimension BackSize BackDimension Cup F_Dimension B_Dimension
22 13 22 13   A
32 18 28   18   B
35 16 28 14   A

June 2nd, 2015 4:30pm

Hi A_Shannon,

Based on your description, my understanding is you wonder to combined FrontDimension or BackDimension column with Cup column. And I test it in my own environment as shown in the following figure:

Please check if the results in column F and column G is your needed. If yes, you can use the formula: =B2&E2 to get the result.

If my understanding is incorrect, please be a bit more precise explain your requirement so that I can get more accurate solutions to this problem.

And you said you wondered to get the result by using a VBA macro, you could post your issue to MSDN forum for Excel:

http://social.msdn.microsoft.com/Forums/en-US/home?forum=exceldev&filter=alltypes&sort=lastpostdesc

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. Thank you for your understanding.

Hope its helpful.

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2015 1:45am

Yes that is the output I am looking for but I would like to use VBA to do it.

Thanks

June 3rd, 2015 8:34am

Hi A_Shannon,

Im not good at using VBA macro, and I found you posted your issue to MSDN forum for Excel. I hope you can find the solution in that forum, good luck. J

Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
June 3rd, 2015 10:08pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics