Forum Discussion

Copper Contributor

Nov 25, 2017

Microsoft Excel keeping all cells uppercase

I have a spreadsheet that several people use and would like to keep the text in a particular column always set to upper case. Regardless of case the user enters the data in this column it is saved i...

excel

Excel Online

nabilmourad

MVP

Jul 04, 2019

Greg Daughenbaugh

This is a very special situation by the way...

The solutions provided by @Haytham Amairah are great.

However you want to treat the different words in the same cell differently!!

I suggest:

1- Select the range (assuming column A) that you want to fix >> Data Tab >> Text To Column

2- Data Tab >> Text To Columns (Should have blank columns to the Right) >> Check "Delimiter" >> Check "Space" >> Finish

3- In Cell D1 write the Formula that fixes the capitalization as desired

'=IF(NOT(EXACT(LOWER(A1),A1))=FALSE,PROPER(A1),A1)&" "& IF(NOT(EXACT(LOWER(B1),B1))=FALSE,PROPER(B1),B1)&" "& IF(NOT(EXACT(LOWER(C1),C1))=FALSE,PROPER(C1),C1)

4- Copy the formula down

5- Copy All results in Column D >> Then Paste Values (CTRL + C >> ALT E S V >> Enter)

6- Delete the Columns A, B, C

Hope that helps

Nabil Mourad