Excel - Use the LEN and SUBSTITUTE Functions to Make an Excel Formula for Word Count

4.0 (5)

37 learners

What you'll learn

This course includes

39.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

excel functions excel formulas exel formulas exel functions len function len function in excel excel len excel len function excel substitute excel substitute function excel word count word count in excel

Full Transcript

Learn how to create an Excel formula that will perform a word count for you. By using the LEN function and the SUBSTITUTE function, you can make a formula that will let you know how many words are in a particular cell or range of cells. Join this channel to get access to perks: https://www.youtube.com/channel/UCYUPLUCkMiUgiyVuluCc7tQ/join ***Consider supporting Technology for Teachers and Students on Patreon***: https://www.patreon.com/technologyforteachersandstudents Here's my entire playlist of Excel tutorials: HTTP://bit.ly/tech4excel Please say "Thanks" by clicking the Thanks button below the video. Here are the practice files for this video: https://bit.ly/excelwordcount #excel #exceltutorials #microsoft365 #microsoftexcel