Step 03 of 40: TRIM/SUBSTITUTE Functions
NOTE: Amounts should be derived by formulas. You will only receive partial credit if you type in words in the cells instead of using formulas.
This step demonstrates how to use the TRIM and SUBSTITUTE functions in Excel to clean up text in a worksheet.
The slide is broken down into two steps, each accompanied by instructions and examples:
- Using the TRIM Function
Use the TRIM function in cells A12, A13, and A16 to remove any extraneous spaces from the text in cells G12, G13, and G16.
The provided example formula is =TRIM(G12), which removes unnecessary spaces from the text in cell G12.
- Using the SUBSTITUTE Function
- Use the
SUBSTITUTEfunction to in cells A19:A23 to remove the word "Assumption" from the text in cells G19:G21.
The provided example formula is =SUBSTITUTE(G19, "Assumption", "") . This formula searches for the word "Assumption" in the text of cell G19 and replaces it with nothing, effectively removing the word.
Note: SUBSTITUTE is not case-sensitive, which means it will replace "Assumption" regardless of whether it appears as "ASSUMPTION," "assumption," or in any other case format.
Steps labeled YOUR TURN are reinforcing steps that present opportunities to apply concepts covered earlier in the assignment.
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.
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.