Forum Discussion
UPPER Not Working
I am trying to make 'J' column upper case in 'K' coloumn. What am I doing wrong? Both columns are 'Text' columns. The file is in 'OneDrive'.
Phishdawg Column K may have been formatted as text before you entered the formula or you accidentally pressed Show Formulas on the Formula ribbon.
Press it again!
I changed the column to text.
I was prepping the doc to become a SharePoint list.
I was unaware that making the column a 'Text' column would impact my ability to use formulas.
I was prepping the doc to become a SharePoint list.
I was unaware that making the column a 'Text' column would impact my ability to use formulas.
Phishdawg Not sure if you got my point. Your issue will arise when you format the column as Text before you enter the formula. Entering the formula first and then setting the column to text will work. Though it will not really matter, I think, as UPPER will return a text string by default even when the column format is General.