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

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://ift.tt/1cUZVo3 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