Excel - IF Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

if both first letters are capital, excel will keep only the first one capital
Solved by O. F. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 02/04/2018 - 03:51
Hello! could you state again the problem and provide example on the document preview on the left?
User 02/04/2018 - 03:52
when I type lets say "HEllo" and press entre, it'll write "Hello"
User 02/04/2018 - 03:53
yeaaah... works here
Excelchat Expert 02/04/2018 - 03:53
kindly see C3
Excelchat Expert 02/04/2018 - 03:53
does that answer your question?
User 02/04/2018 - 03:54
I actualy need the first 2 letters to be capital
User 02/04/2018 - 03:54
in this file it doesnt seems to do the problem
User 02/04/2018 - 03:55
im using excel 2007
Excelchat Expert 02/04/2018 - 03:56
I don't know if I can follow your problem correctly
User 02/04/2018 - 03:57
I need the first 2 letters to be capital, but when I write it the way I want, excel thinks I made a typo and keeps only my first letter capital
Excelchat Expert 02/04/2018 - 03:57
If it is a software troubleshooting issue, I may not be able to help as it is out of scope of Got It Pro's services
User 02/04/2018 - 03:57
ho ok
User 02/04/2018 - 03:57
thanx anyways
Excelchat Expert 02/04/2018 - 03:58
on a side note, you may want to check your autocorrect functionality in excel
User 02/04/2018 - 03:58
HO! good! thanx Ill check!
Excelchat Expert 02/04/2018 - 03:59
File>Options>Proofing>Autocorrect Options
Excelchat Expert 02/04/2018 - 04:00
uncheck TWo INitial CApitals checkbox
Excelchat Expert 02/04/2018 - 04:00
I hope that helps you with your problem
Excelchat Expert 02/04/2018 - 04:01
Are you still there? Is it okay if I end the session and mark it solved?
User 02/04/2018 - 04:05
yeah IM busy but im sure thatll do thanx a lot
Excelchat Expert 02/04/2018 - 04:06
Great! Good bye

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc