I don't know enough about macros to know where to start with this, but here's what I need in the attached file. Hopefully someone can help me.
On column I, the following needs to be done:
1. Loop through the column until no values are found
2. Perform the following functions
a. Remove/delete the first 3 characters
b. Next, if there is a leading space after deleting the first 3 characters, delete the leading space.
c. Then delete the last 8 characters (is a date) plus the space before the date.