So i have a table created in Excel. I want to have a macro which allows me to fill a certain cell (lets say "B1") with the cell values from cell "A1" and "A2". Also i want that at the end of the cell there always is a "mm", if that makes any sense.
Basicly what i want is the excel formula
as a macro.
What i mean is:
Basicly what i want is the excel formula
Excel Formula:
=SUBSTITUTE(A1;"_";" ")&" x "&A2&"mm"
What i mean is:
Inputs | Outputs |
ISO_4014 | ISO 4014 x 50mm |
50 |