Excel Training: String Parsing with Formulas and Power Query

During this live training I'm going to explain solutions to the License Plate Challenge we ran a few weeks ago.

-- LINKS --

*** JOIN OUR COMPREHENSIVE EXCEL TRAINING PROGRAM***

The challenge was based on a system implemented at Yellowstone National Park to limit the number of visitors to the park. It required string parsing techniques with formulas (or Power Query) to determine if a license plate could enter the park on an even or odd date.

We had a ton of great solutions posted on our blog and YouTube video. I'm going to go over some of the techniques and explain how they work. You will learn a lot about parsing and analyzing strings of text and numbers in Excel.

[Excelambda]

Wow, Thanks Jon for all the efforts you put in these challenges and following surveys. Impresive !! Great solutions everyone!!✌🙏

[susanwhite]

Excellent Job Jon! I learned so much. This was difficult being that it had so many different solutions and some features are an entire training video. I will use the files for future reference and for training as well.

[khalidmajeed]

happy friday to you sir, , , Allah giive u all happiness of liife, , , , aameen

[PaulEBrownbill]

Excellent webinar Jon, enjoyed seeing the solutions. Paul

[VisuLytics]

You have a great voice man...Great session, I have learnt a lot from your videos

[alwinrosete]

Alwin from Baguio, the cool city of the Philippines😆

[platypi_otbs]

I really need to learn more about dynamic arrays.

One thought that kept distracting me through the video is thinking about how people with odd license plates are lucky. There are 8 more odd days in a year plus an extra if it's a leap year. It's very easy to distract me.

[ganeshtiwari]

hello sir how can a beginner start from basic sir can u suggest