How to replace string values

[romachainani]

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!

[alexnajm]

Formula should do the trick:

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

[binuacs · Accepted solution]

@romachainani One way of doing this

[ShankerV]

Hi @romachainani 

One way of doing this.

Many thanks

Shanker V

[MilindG]

@romachainani 

[romachainani]

Thank you so much binuacs!