Hi,
I have a list that I need to extract data from in Excel. I have names in the following format:
John & Mary Smith
Bill Jones & Jenny Davis
Bob Edwards
I need to get the salutations from this list so that I have a separate column with the following:
John & Mary
Bill & Jenny
Bob
Is this possible? It is a list of 10,000 names and too hard to go through manually.
Thanks!
I have a list that I need to extract data from in Excel. I have names in the following format:
John & Mary Smith
Bill Jones & Jenny Davis
Bob Edwards
I need to get the salutations from this list so that I have a separate column with the following:
John & Mary
Bill & Jenny
Bob
Is this possible? It is a list of 10,000 names and too hard to go through manually.
Thanks!