I'm using find to remove some of the test string in lookup cell value
For instance I look-up the following in cell A2 Application: sales_rep_support
and use find =RIGHT(a2,FIND(" ",a2)+4)
to change it to sales_rep_support
.
However I run into problems because I have other values that need parsed such as
Application: EComm_sk
Application: PG_Prescreen
Application: sales_rep_support
Application: Retention_sk
etc....
What I have been trying to accomplish is simply remove the Application:
from the beginning of the string
I have also tried left()
unsucessfully.