Trevor3007
Well-known Member
- Joined
- Jan 26, 2017
- Messages
- 667
- Office Version
- 365
- Platform
- Windows
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
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