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!
Solved! Go to Solution.
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