Hi,
I have a comment section (N) that everyone put their initials or name in instead of the cell (O) . Is there any way that excel can recognize their identifier ( initials, name etc.) within the cell (N) and then put the initials or name in cell in column (S).
I have tried text to columns but since the initials are not uniformly placed in the same spot sorting it has become a nightmare. I have over 50,000 rows like this.
Every comment the each person worked, they used the same identifier.
I think I am looking for a Macro or some sort of searching v-look up but I have no idea how to do that.
I have a comment section (N) that everyone put their initials or name in instead of the cell (O) . Is there any way that excel can recognize their identifier ( initials, name etc.) within the cell (N) and then put the initials or name in cell in column (S).
I have tried text to columns but since the initials are not uniformly placed in the same spot sorting it has become a nightmare. I have over 50,000 rows like this.
Every comment the each person worked, they used the same identifier.
| N | O | P | Q | R | S |
| Comment | n/a | n/a | n/a | n/a | Name |
| This is my comment. JD | John Doe | ||||
| Roger This is my next comment. | Roger That | ||||
| JS - comment | John Smith |
| Attendee Initials | Attendee Name |
| JD | John Doe |
| Roger | Roger That |
| JS | John Smith |
I think I am looking for a Macro or some sort of searching v-look up but I have no idea how to do that.
