Excel Concatenate Macro

test1.xlsx

I have a need for an extended description and it is accomplished by concatenating. The problem is that the number in the string is different everytime. The formula should be based on the material #. I have attached a file. Column F is isgnored for the macro formula.

Cell F31 has the following formula:

=+G23&" "&G24&" "&G25&" "&G26&" "&G27&" "&G28&" "&G29&" "&G30

The macro formula should be placed in column F in the line below the material #.

Thank you.

Or...maybe this is just an if formula.

Please Login or Register  to view this content.

Thank you. Works perfectly!

Wondering if Column H after the macro for the concatenate if a formula can be entered to show the character length of the field populated by the macro. Thanks.

Please Login or Register  to view this content.