My 1st ll rows consist of a dashboard. There is not data in these 11 rows.
I have 2 columns with data.
Column 3 has a permanent list of names with no leading spaces.
Column 8 has a list of names that:
1. Some words have no leading blank spaces.
2. Some words have 1 blank space in front of them.
3. Some words have 2 blank spaces in front of any word.
I need to have a macro that deletes all leading blank spaces in all words in column 8. When all leading blank spaces have been cleared, All the names in Column 8 need to be appended to column 3 at the bottom of the column.
Bookmarks