Here is what I tried to do and it gave me an error 'Sub or function bot defined':
And the cell value in this case is: PFD987_TDW38 is loaded into group 367-b
So this is what is needed: No matter where the P* string is and regardless the number of characters in the P* string:
1) pick it out of the string in the cell
2) using keyword loaded or load, replace whole cell with "SITE LOAD-SITE NAME = PFD987_TDW38"
Another example would be:
Cell Value - "There was a site load for site PCHYU7896_FG_TY_12"
new cell value - "SITE LOAD-SITE NAME = PCHYU7896_FG_TY_12"