Upper Case, Sentence case Help

[Manolocs]

Hello, I have on column A a big list of words, cells contain one, two or several words.
What I need is:
1-If the cell contains only one word, make this word in UPPER Case
2-If the cell contains more than one word, make the cell in SENTENCE CASE.
Is it possible?
Thanks in advance

 

[teylyn]

Hello,

if the cell contains more than one word, then it must contain a space character. That is where you can hook into, like this:

=IF(ISNUMBER(FIND(" ",A1)),PROPER(A1), UPPER(A1))

cheers, teylyn

 

[Manolocs]

@ teylyn This was great.... thank your for the formula. Works the way I needed.

 

[teylyn]

You're welcome. Glad it worked for you.