Using the =PROPER(text) Function

%3CLINGO-SUB%20id%3D%22lingo-sub-2144390%22%20slang%3D%22en-US%22%3EUsing%20the%20%3DPROPER(text)%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2144390%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20convert%20a%20column%20of%20text%20that%20has%20multiple%20words%20in%20each%20cell%2C%20but%20all%20caps.%20I'm%20trying%20to%20use%20the%20formula%20%3DPROPER(TEXT)%20as%20suggested%20by%20the%20%22HELP%22%20function%2C%20but%20it's%20not%20working.%20I%20created%20a%20column%20to%20the%20right%20of%20the%20text.%20I%20entered%20the%20formula%20in%20the%20new%20column%20and%20tried%20to%20copy%2Fpaste%20the%20formula%20over%20the%20original%20text%2C%20but%20all%20it%20does%20is%20copy%20the%20formula.%20What%20am%20I%20doing%20wrong%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2144390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2144406%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20the%20%3DPROPER(text)%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2144406%22%20slang%3D%22en-US%22%3E%3CP%3EPROPER%20function%20should%20work%20pretty%20fine.%3CBR%20%2F%3E%3CBR%20%2F%3ELet%20say%20you%20have%20DONE%20in%20cell%20A1.%20In%20cell%20B1%2C%20enter%20%3DProper%20(A1)%20and%20hit%20enter.%20It%20should%20deliver%20Done%20in%20cell%20B1%3CBR%20%2F%3E%3CBR%20%2F%3EI%20suggest%20you%20close%20your%20Excel%20workbook%20and%20reopen%20and%20run%20the%20formula.%3CBR%20%2F%3ECheers%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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?

2 Replies

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

Try Paste Special - Value (from the paste button on the home tab).