Difference between FIND and SEARCH function in Excel

There are two similar functions in Excel that allow one to search for the position of a character in a text string. The function are the FIND() and SEARCH() functions. They are so similar till one wonder why have two function that perform identical task? However, there are key differences between the two.

The FIND() function is case sensitive whereas the SEARCH() is not case sensitive The other differences is FIND() function does not accept wildcard character whereas the SEARCH() function does.

Both function can search single character, words and symbol within a sentence or text string.

Proper function and it's imperfection in Excel

Upper, Lower and Proper function allow us to deal with messy letter case in Excel.

The Upper() function allows us to convert all lowercase letters in a text string to uppercase.

The Lower() function helps to exclude capital letters in a text string.

The Proper() function makes the first letter of each word capitalized and leaves the other letters lowercase.

There are however some imperfections for the proper functions.

One of the imperfection is that when we try to convert string that contain apostrophe s, it also convert the small letter s to big letter s.

The second imperfection of the Proper function is that when a sentence contain I or II that represent one or two, for example, when we are referencing a movie, Spiderman II, it convert the II into ii.

The third imperfection of the Proper function is that when we are converting text string that contain state code, it will also convert the state code into small letter, example, from California, CA to California ca.

The workaround for these imperfection will be using the Proper function together with the Substitute function.

Check out the video to learn in detail on the Upper, Lower and Proper function.

Fill down blank cell fast in Excel with three different methods

This video demonstrates how to fill down blank cells until the next value using formula, power query and VBA macro methods.

So which method to use? Well, It's all about choices.

The formula method is traditionally a popular choice among many excel users.

Power Query gives excel user that hate formula another choice.

VBA code gives excel user that love coding to fill down the blank cells more efficiently.