I am looking for a macro that will work with column A and B. First I would like to concatenate column A with column B, however column B has unwanted spaces in it, so I need to TRIM out or CLEAN column B either before or after. Is there an easier way to do this by the column instead of having to copy the formula down and copy/paste specail values etc. There is no set number of rows, which can change from day-to-day.
Would like to automate this. Please advise and thanks. -R-