Making Specific Letters Uppercase and Adding Characters to Specific Positions

RD

Spoiler

Question1: I would like to make some letters "uppercase letters".

For example the cell may read: 

Title: random is great

Title: Random is bad

Title: easy is great

I was thinking how do I make the letter following a column either upper case or lower case to make it consistent across all my cells.

Using: Uppercase(Left([Title], 8)) + Substring([Title], 8, Length([Title]))--> I get TITLE: Random is great which is almost what I am looking for.

I would prefer it to be: Title: Random is great where the whole word title does not get capitalized and only make the 8th element uppercase.

Question 2: Similarly, how can I add the column right after Title on the 6th position?

Title Random is bad --> Title: Random is bad

Thanks!

MarqueeCrew

@RD

Below, I am converting column 1 to uppercase and column 8 to uppercase.

uppercase(substring([Text],0,1)) +
substring([Text],1,6) +
uppercase(substring([Text],7,1)) +
substring([Text],8)

You can convert tiTlE to Tilte: (case inSEnsItIVE) with:

REGEX_Replace([TEXT],"title ",'Title: ',1)

Hopefully, this helps you.

Mark