Not Proper!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hey

I've been using the proper function this morning and its not working for
some reason.

Cell B3 contains the word: MISS
I want cell C3 to contain the word: Miss
So, in cell C3 I typed: =proper(B3)

But it didn't work. Cell C3 has =proper(B3) in it. Not Miss.

Any ideas?
 
C3 was probably formatted as text, unknown to you. Just format C3 as either
general or number, then click inside the formula bar, press ENTER to
re-confirm.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with Excel and Flagging Outcomes! 4
Excel Help to copy information from one row at a time to another sheet 1
product code a value 0
SUM / COUNT formula 3
My Duplicate formula is not functioning as it should 3
IF STATEMENT 19
Data Validation Formulas 3
Formula confusion 4

Back
Top