Hi @ClaytonM,

Thanks for your response!

Capital I doesn’t work

My write cell input looks like this:

“=PROPER(MID(I2,1,FIND("""","""",I2,1)-1)) & “”"", “”""&UPPER(RIGHT(I2,2))"

Message box:

There are extra “” around the ,

So I tried to put only 3 "s around the , instead of 4 -> error: end of expression expected.

Any idea? Thanks

Edit:

Also, the color of the formula is not in the standard string dark brick-red color…

“=PROPER( ->Black

MID -> Blue

(I2,1,FIND( ->Black

“”"","""" -> Red, Black, Red

,I2,1)-1)) & “” -> Black

“, “”"&UPPER(RIGHT(I2,2))" ->Red

…

I tried to use Type Into but it wouldn’t let me press Enter

(still: extra " around ,)

All I could do is to press ESC…and clear out the formula…

Change the formula to

“=proper(left(I2, len(I2)-2)) & upper(right(I2, 2))”

and works. still want to know how to make the following works though if someone has insights.

“=PROPER(MID(I2,1,FIND("""","""",I2,1)-1)) & “”"", “”""&UPPER(RIGHT(I2,2))"

and the type into formula issue if anyone comes across and have a solution.

Thanks