Mirandazhou
New Member
- Joined
- Sep 25, 2015
- Messages
- 9
Hi everyone, I'm relatively new to VBA and I am really struggling with the following task..
I am creating a huge excel file, and need to find out the names, from one row
<tbody>
</tbody>
I have keyword table as
<tbody>
</tbody>
The names shows in different format, sometimes James LEE, LEE James, James M Lee, so I cannot use lookup function directly in excel...
I really appreciate for the help! Thanks!
I am creating a huge excel file, and need to find out the names, from one row
James LEE went to mall today | James, Lee |
Rental payment for Lee James | James, Lee |
Orders for JAMES LEE | James, Lee |
Kim Chazen got hired | Kim, Chazen |
Salary for Kim Chazen | Kim, Chazen |
<tbody>
</tbody>
I have keyword table as
Kim, Chazen |
James, Lee |
Yang, Wang |
<tbody>
</tbody>
The names shows in different format, sometimes James LEE, LEE James, James M Lee, so I cannot use lookup function directly in excel...
I really appreciate for the help! Thanks!