Feb 17 2021 01:34 PM
I am trying to convert a column of text that has multiple words in each cell, but all caps. I'm trying to use the formula =PROPER(TEXT) as suggested by the "HELP" function, but it's not working. I created a column to the right of the text. I entered the formula in the new column and tried to copy/paste the formula over the original text, but all it does is copy the formula. What am I doing wrong?
Feb 17 2021 01:40 PM - edited Feb 17 2021 01:42 PM
PROPER function should work pretty fine.
Let say you have DONE in cell A1. In cell B1, enter =Proper (A1) and hit enter. It should deliver Done in cell B1
I suggest you close your Excel workbook and reopen and run the formula.
Cheers
Feb 17 2021 05:43 PM