K
Karin
Hi,
Here's the string I need to extract from: Regional Sales: SMITH, E.
(330146)
Here's what I want to end up with: SMITH
All the rows contain the same beginning (Regional Sales: ) space), it's
the length of the last name that varies, but all of the last names end with a
comma. I've been spinning my wheels, I know I'm close, but I just can't get
it. TIA
Here's the string I need to extract from: Regional Sales: SMITH, E.
(330146)
Here's what I want to end up with: SMITH
All the rows contain the same beginning (Regional Sales: ) space), it's
the length of the last name that varies, but all of the last names end with a
comma. I've been spinning my wheels, I know I'm close, but I just can't get
it. TIA