Forum Discussion

dstoloff0366's avatar
dstoloff0366
Copper Contributor
Feb 17, 2021

Using the =PROPER(text) Function

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?

Formulas and Functions

2 Replies

  • JMB17's avatar
    JMB17
    Bronze Contributor
    Feb 18, 2021
    Try Paste Special - Value (from the paste button on the home tab).
  • Abiola1's avatar
    Abiola1
    MVP
    Feb 17, 2021

    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

Resources