How to replace string values

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!

Accepted answers

@romachainani One way of doing this

Screenshot 2023-07-20 210826.png

Formula should do the trick:

IF !Contains([Column],"_") THEN Uppercase([Column]) ELSE [Column] ENDIF

@romachainani One way of doing this

Screenshot 2023-07-20 210826.png

One way of doing this.

Screenshot 2023-07-21 014001.jpg

Many thanks

Shanker V

Thank you so much binuacs!