I tried recording a macro to convert a table copied from excel to word, but in record mode "convert table to text" is greyed out.
Step 1. After pasting the table to word I need to convert table to text paragraphs.
Step 2. Replace all spaces with tabs
Step 3. Remove hanging tabs (^t^p replaced with ^p)
Step 4. Remove periods.
Step 5. Remove commas.
Step 6. Replace JR with JR.
Step 7. Convert text to table by tabs
Page one is before and page two is after.
Thanks for any help you're able to give.