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.