I'm hoping someone can write the macro code to do the following to the attached file.
Step 1: Remove any spaces AFTER the last character in column C
Step 2: Take all characters after the first space in column A and put it after the last character in column C (with a space between the original character string in column C and the new text to be placed there
Row 7 shows exactly what I want the end result to be. The original file is in the tab named "Before". I'd like the end result to be in the tab named "After"
Can someone help?