Text Manipulation Functions

In this video we look at a few text manipulation functions: LEFT(), RIGHT(), LEN(), FIND() and the honorable mention, MID(). These functions allow for manipulating text in cells based on positioning We'll go through an example to create first name initial and last name emails using these functions. -- Current Section: ➡️Section 6: Functions https://docs.google.com/spreadsheets/d/1yXw6KFj5JrPHBuAHHpHzSB4JZfvhxcJ6KEBsUiHTL5Y/copy Previous Sections: ✅Section 1: Organization https://docs.google.com/spreadsheets/d/1SbRW5LJS5P1A5ZA1hxZv3Hnv3bos-dl-e0F96KCuLrA/copy ✅Section 2: Formula Building https://docs.google.com/spreadsheets/d/1nQF5cN3F_QienoZ2hK87L_xoC0Rc8apNrm7PVA5LaHo/copy ✅Section 3: Data Validation https://docs.google.com/spreadsheets/d/1kA9gqFX1d-tAA-y6vWUHAtS9xglwCOAx2XuHodrkkJc/copy ✅Section 4: Sharing https://docs.google.com/spreadsheets/d/1cqc0-arYUW-lLGnhkr4mrcwarRupyavHjJ4c6RmDfCE /copy ✅Section 5: Numbers https://docs.google.com/spreadsheets/d/1FsoYxdQImDyBMHcqtqw0NBhQbQcPNyg67tXYd8qw0gs/copy -- 🗣️Socials: WEBSITE: https://matttechtidbits.github.io/matttechtidbits/ REDDIT: https://www.reddit.com/user/MattTechTidbits LINKEDIN: https://www.linkedin.com/in/matthew-klemme-ba9126b2?trk=pub-pbmap INSTAGRAM: https://www.instagram.com/matttechtidbits/ Need a Freelancer? Check out my Upwork Profile: https://www.upwork.com/freelancers/~01e15eefe1443fcea1 – ⏳Timestamps: (00:00) Introduction (01:01) LEN() Function (02:38) LEFT() Function (03:07) RIGHT() Function (03:34) FIND() Function (04:18) Find the Lastname with LEN(), FIND(), and RIGHT() (07:16) MID() Function Alternative (09:03) Conclusion (09:24) End Slides LINK 01:50 structured table 4:22 New Table Footers 🎵Music is "WFH" made by me with my solo music project name, @Ambiosynthesis https://www.youtube.com/watch?v=sKi5cGTQoBM — Tags: #googlesheets #spreadsheet #technology #sheets