change case based on word

[Trevor3007]

hi,

hoping this finds well & safe.

I hope someone can resolve my issue?

Is it possible so that certain words in a range ie :F26-F100, can be forced to either upper \proper or lower.
so:-
if 'wip' is put into f26, it will be forced to WIP
if 'completed 'is put into f27, it will be forced to Completed
if 'tba 'is put into f27, it will be forced to To Be Advised
etc...

So, if any of the applicable is inputted in to the range (F26-F100) it will 'case,CASE, \Case,' accordingly.



Hoping this makes sense & I look forward to receiving your replies.

KR
Trevor3007

 

[Trevor3007]

No worries in your own time.
If you followed instructions where to place the codes & are making direct entry one cell at a time, solution should have done what you asked for.

Are you able to place copy of your workbook in a dropbox (with sensitive data removed) this will give forum better opportunity to understand the issue

Dave

Thanks..
I will send and as soon as.
Stay safe.