I have a column that has these values:
abc_def
abc
lmn_op
lmn
In the example above:
I want abc and lmn to be capitalized but I want abc_def and lmn_op to remain as is:
abc_def
ABC
lmn_op
LMN
How would I go about doing this?
Thank you!
Solved! Go to Solution.
Formula should do the trick:
IF !Contains([Column],"_") THEN Uppercase([Column]) ELSE [Column] ENDIF
@romachainani One way of doing this
Thank you so much binuacs!