Excel: Convert text to proper case

https://www.youtube.com/watch?v=6Eipo7oVeqk&feature=share

Formula to convert text to proper case =proper(text)

Proper case converts first letter into upper case and rest of the letters to lower case for every word.

Comments

Post a Comment

Popular posts from this blog

What is unit testing

https://www.youtube.com/watch?v=h9RvPN3kiHk&feature=youtu.be   Testing of individual software components or units or modules. Typically unit testing is done by the programmer and not by testers. Unit is smallest and complete set of code which accepts input, processes and gives output The primary goal of unit testing is to take the smallest piece of testable software in the application, isolate it from the remainder of the code, and determine whether it behaves exactly as you expect.
Read more

Regression Testing

https://www.youtube.com/watch?v=qaANTCZt20g What is Regression testing? It is a type of software testing that verifies that software performs correctly after the change or defect fix. Changes may include software enhancements, patches, hardware, networking, data structure, configuration changes, etc. In other words purpose of regression testing is to identify that  new defects are not introduced in the system after the change. 2) At what levels regression testing should be done? At all levels mainly Unit Testing, Integration testing and System Testing: Focus on testing is different at different levels. 3) What are the types of Regression testing techniques? Corrective Regression Testing: Progressive Regression Testing: Retest-All Strategy:. Selective Strategy: (dependencies between a test case and the program entities it covers) 4) What should be the frequency of regression testing? Ideally Regression testing should be done after bug fix and after any change to the syste
Read more