Why Short Excel Formulae Are Better Than Long Excel Formulae (WITH PRACTICAL DEMO)

Ever wanted to extract specific text from a text entry in Excel?  This video covers how to extract text after a hyphen (-) or extract text between hyphens from text in a cell in Excel.  We use Excel's FIND, LEN, RIGHT, SEARCH and MID formulae to get the job done. 

Members' Monday FREE 1-hour taster session

CLICK HERE TO WATCH THE VIDEO

Topics :

00:00 Excel Text Formula Task Introduction

00:32 Excel FIND Formula Demo

00:52 Excel LEN Formula Demo

01:26 Excel RIGHT Formula Demo

02:08 Why More Columns And Shorter Formulae Is Better

03:11 Excel SEARCH Formula Demo

04:46 Excel MID Formula Demo

05:51 Members’ Monday Excel Learning Community

It's a complex task that could require a long Excel formula.  In the video, I demonstrate how to simplify this Excel task by using multiple columns and shorter, easy-to-understand formulae.  This Excel modelling approach should allow you to build up complex functions step-by-step, whilst retaining a clear audit trail - and preserving your sanity.

ABOUT MEMBERS' MONDAY

This video is taken from our unique and exclusive Members' Monday learning community.

Looking to build your data analysis skills in a supported environment with expert access, with a group of like-minded individuals?

Need structured materials with a practical focus, and a place to go for help?

Want to take a long-term approach to your learning and get real improvement, rather than lurching from one problem to the next?

You'll love our Members' Monday community!

"Joining this community was a smart investment" - MEMBER FEEDBACK

Members' Monday FREE 1-hour taster session