reader6886
New Member
- Joined
- Sep 10, 2020
- Messages
- 25
- Office Version
- 2019
- Platform
- Windows
Hello all.
I have a excel worksheet like below . The name in the authors column are always mixed up ( firstname surname , surnam firstname etc , I will have a column in separate sheet with all the author name variation to compare like in second pic ). I have 2 questions.
1. Is there a way to standardize the authors column with one name format not different variation of the same name , like fistname surname all the time.
2. How can I delete the whole row if the author doesnot matches from the compare list .
Thank you so much .
I have a excel worksheet like below . The name in the authors column are always mixed up ( firstname surname , surnam firstname etc , I will have a column in separate sheet with all the author name variation to compare like in second pic ). I have 2 questions.
1. Is there a way to standardize the authors column with one name format not different variation of the same name , like fistname surname all the time.
2. How can I delete the whole row if the author doesnot matches from the compare list .
Thank you so much .