Forum Discussion

Phishdawg's avatar
Phishdawg
Brass Contributor
Aug 28, 2023

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'.

Formulas and Functions

3 Replies

Sort By
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Aug 28, 2023

    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!

    • Phishdawg's avatar
      Phishdawg
      Brass Contributor
      Aug 28, 2023
      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.
      • Riny_van_Eekelen's avatar
        Riny_van_Eekelen
        Platinum Contributor
        Aug 28, 2023

        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.

Resources