Hello,
I have an Excel table that has a fixed number of columns but the number of rows can vary depending on the data update. The columns have a header row.
I want to use VBA code to concatenate the text contents of Column F and H with an underscore in between and place the contents in Column J.
E.g. Cell F2 has "FC TAB" and Column H2 has "Allegra Plus". The result in Cell J2 would be "FC TAB_Allegra Plus"
Thank you.
I have an Excel table that has a fixed number of columns but the number of rows can vary depending on the data update. The columns have a header row.
I want to use VBA code to concatenate the text contents of Column F and H with an underscore in between and place the contents in Column J.
E.g. Cell F2 has "FC TAB" and Column H2 has "Allegra Plus". The result in Cell J2 would be "FC TAB_Allegra Plus"
Thank you.