Excel comes with a vast amount of handy formulas that we do not have to create from scratch. These formulas range from data cleaning to financial formulas a CPA may use on a daily basis. In this section we will cover some of the common ones every Excel developer should be aware of.
Fire up Excel 2013 and create a new spreadsheet. Manually enter the following information:
The goal of this exercise is to remove the $ character from the String column. We will use two Excel functions to accomplish this task:
In cell B2, type
=find("$",A2)
, as shown in the following screenshot. Note that this search is case sensitive.The
find
function will look for a string within a string. If it finds a match, it returns the integer position of the location. The first parameter asks us to enter the string that we are looking for. In our case, it is the dollar sign. The second parameter asks us to enter the location of the string that we will be searching for. In our case, the location is...