Microsoft Office is a powerful service that helps you release your best ideas to get things done and visit associated on it is go.MS Office applications with new and enhanced features continually being added. It is Microsoft Excel spreadsheet platform that features calculation, graphic tools, pivot tables, and macro programming language support for programs commonly used in an office situation. There are various function of MS office in.

Thursday, June 18, 2020

Excel PROPER case Formula

It is an Excel PROPER function capitalizes fist words given text string. Numbers and punctuation are not pretentious.


Santax :- =PROPER(TEXT) Enter

Example  Step :- =PROPER(G4) Enter
 

1.       It is use to PROPER case capitalize each word in a given string.

2.       All letters in text will be converted to lower case before the first letter in each word is capitalized.

3.       It’s numbers and punctuation characters are not affected.



No comments:

Post a Comment

if you have any doubt let me known will
give suggestion in this site

Thank you so much

https://www.youtube.com/channel/UC-ydS7go5OShxe0MIeUMwUg

How to use Goal Seek in Excel for What-If analysis #sk excel trick

 How to use Goal Seek in Excel for What-If analysis #sk excel trick What-If Analysis is one of the most powerful an Excel features and one o...

https://www.youtube.com/watch?v=FHsEvT-UpDA&t=6s