Hi-
I've searched for an exact solution to this but am coming up slightly short. I have cells with the following data:
C2=Duke 82, Kentucky 76
I want to extract Kentucky in separate tab/cell. The number of characters extracted needs to be variable too.
I'm sure it's a mid formula, but haven't been able to get one to work.
Thanks in advance for the help.
I've searched for an exact solution to this but am coming up slightly short. I have cells with the following data:
C2=Duke 82, Kentucky 76
I want to extract Kentucky in separate tab/cell. The number of characters extracted needs to be variable too.
I'm sure it's a mid formula, but haven't been able to get one to work.
Thanks in advance for the help.