Without code you have to use individual cell formulas to change text to upper or lower.
To convert all the text in say column A from lower to upper, find an empty column, say column K, and type the following formula in K1
then fill this formula down to as many cells as you need
You can then copy column K and use Paste Special > Values to paste it back into column A
Hope this helps. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
First, let me know if you were able to try the formula that I gave you for changing case.
If so please go ahead and click Accept so I can continue helping with the other issue
What was the problem? Would you like me to send you a sample file to show you how it works
Ok here is a sample file
The formulas are in the yellow cells. Try typing data in column A and see how the case changes in column B and C
Hope this is ok. Let me know if you have any questions, and thank you for clicking Accept if you are satisfied with the solution
Ok what happens when you try to click Accept, do you get an error message?
Anyway to contact JustAnswer you need to send an email to firstname.lastname@example.org or to info@justanswer,com
If you still need help let me know and I will try to have a moderator contact you
Ok but you have not accepted my answer yet. Please first click Accept so I can get paid for assisting you (that is the only way I get credit for helping)
Did you send email to JA customer service email addresses that I gave you. If not, please do so in order that I can make reference to these emails when I contact the site moderator to help you