cansevin
asked on
Take Name out of Cells
In excel I have a column of data with information including a name. They look like this:
QuickPay with Zelle payment to John Doe 7135261870
In the next column, I need it to take out just the name. The names are always right after the word "To" and before the number which always starts with a 7.
Thanks!
QuickPay with Zelle payment to John Doe 7135261870
In the next column, I need it to take out just the name. The names are always right after the word "To" and before the number which always starts with a 7.
Thanks!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No Comments added further
=MID(A2,FIND(" to ",A2,1)+4,FIND(" 7",A2,1)-FIND(" to ",A2,1)-4)
This looks for actual word "to" with a space before and after; in case there is the letters "to" anywhere in the string prior to the word "to". Allowing for a space before the 7 should also find only a string starting with 7.