Update of Partial cell value

  • Hello all,


    I have a cell value that has contents that would say something like "You need to do this for CLIENT NAME. this needs to be done by 30 BUSINESS DAYS and you need to also do xyz by 30 BUSINESS DAYS"


    I'm trying to update the formatting of the words that are all caps (CLIENT NAME and 30 BUSINESS DAYS) so it the output would be "You need to do this for CLIENT NAME. this needs to be done by 30 BUSINESS DAYS and you need to also do xyz by 30 BUSINESS DAYS"


    I have the code below but it only updates the first 30 BUSINESS DAYS string. How would i go about also updating the 2nd 30 BUSINESS DAY string?

    I'm not necessarily stuck with the code above so if it needs to be scrapped for a better alternative, I'd be open to that.


    Any help would be appreciated.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!