Step 02 of 40: FIND/LEFT Functions

This step illustrates how to use the FIND and LEFT functions.

Utilizing LEFT and FIND Functions: The user is instructed to apply the LEFT and FIND functions within cells A7 to A9. The goal is to return all text from the cells G7 to G9, excluding the word "Assumption." The instructions clarify that if this is done correctly, cells A7 to A9 will display the result in red text. Additionally, it's stated that entering the formula correctly is necessary to receive credit for this step in what appears to be an assignment or exercise.

The main body of the slide demonstrates how to construct the formula using the FIND function to locate the starting point of the word "Assumption" in cell G7 and the LEFT function to return all text to the left of this point. The example provided is =LEFT(G7,FIND("Assumption",G7)-2) . The -2 is used to exclude the letter "A" and the space before "Assumption" from the result.

On the right side of the slide, there's a cautionary tip indicating that the FIND function is case-sensitive, as demonstrated by the warning that =FIND("assumption", G7) will return a #VALUE! error because "assumption" is not in the correct case to match the text in G7.

Additional explanatory text boxes elaborate on the use of FIND , specifying that it looks for the word "Assumption" within cell G7, and the use of LEFT , stating that it extracts characters from the text in G7 starting from the left up to the number of characters specified by the FIND function, minus 2 in this instance.

NOTE: Amounts should be derived by formulas. You will only receive partial credit if you type in numbers in the cells instead of the actual formulas.

Be sure to listen to the audio portion of the video as you work through the assignment. The presenter elaborates further on what is being presented on screen and will offer tips.

We're here to help

If you're stuck or confused, send a copy of your workbook by way of one of these methods:

• Share: Click the Share command in the upper-right hand corner of the Excel screen, choose Share again, and then share the workbook with support@studentsexcel.com.

• Upload: You can upload a copy of your workbook at www.studentsexcel.com/student-upload.

• Email: You can email your workbook as an attachment to support@studentsexcel.com.