random capital words

se
Bronze 2
Bronze 2

I have a text-type virtual column with the app formula [word list]-[words I know] resulting in only showing the words missing from the word list. 

[Words I Know] is an enumlist, [Word List] is a list-type virtual column with the app formula LIST(word1, word2, etc).

Everything functions as it should however and words that have 1, 2 or 3 letters from the resulting list are capitalised.  How do I stop this?

Solved Solved
0 2 99
1 ACCEPTED SOLUTION

Please try for the resulting list

LOWER([word list]-[words I know])

If you need the resulting column strictly to be list, you may need to use SPLI() to create a list again.

 

View solution in original post

2 REPLIES 2

Please try for the resulting list

LOWER([word list]-[words I know])

If you need the resulting column strictly to be list, you may need to use SPLI() to create a list again.

 

se
Bronze 2
Bronze 2

Thanks - this worked. Any insight as to why these words were being capitalised?

Top Labels in this Space