Forum Discussion
Using Upper and or Proper Function - not working properly
I am trying to use the UPPER function on my Excel sheet. I was able to format my first column, but when I try the next column, it won't convert. I have tried several times, and it will not convert the function. I have included two screenshots to show the progression. I formatted the column to text, and have tried to troubleshoot any tips I have come across. I have tried both on my desktop and uploaded to my 365 and both have the same result. What am I missing?
The reason that formula is not working is that excel is not recognizing that cell as having a formula because you "formatted the column to text".
So reformat that column back to "General" and then reenter that formula
2 Replies
The reason that formula is not working is that excel is not recognizing that cell as having a formula because you "formatted the column to text".
So reformat that column back to "General" and then reenter that formula
THANK YOU!! Something so simple, totally eluded me. I really appreciate your help!
