The video provides a practical and efficient solution to a common data extraction problem in Excel, using a clear demonstration and a readily applicable function.
The video demonstrates how to extract the year from invoice numbers in Excel using the STXT function. It explains how to identify the starting position and the number of characters needed to isolate the year, then applies this to a list of invoice numbers.
Compétence à avoir : extraire une date cachée dans un numéro de facture 🔎 Avec STXT, vous l'extrayez automatiquement. Vous donnez la position de départ, le nombre de caractères, et c'est réglé. Plus jamais besoin de compter les chiffres à l'œil. #excel #exceltricks #exceltips #tuto #creator
Pour 17h:
Introduce the problem: extracting years from invoice numbers.
Explain the STXT function and its arguments.
Demonstrate extracting the year from the first invoice number.
Apply the function to the entire list of invoice numbers.
Conclude by emphasizing the efficiency of the method.
Excel ACTS - it is used to extract data from invoice numbers. Removing it would change what happens in the video. STXT ACTS - it is an Excel function used to extract data from invoice numbers. Removing it would change what happens in the video.
Playing this video’s own audio, so you’ll hear the creator over the sound.
Promotes 1 product. Create free account to see more.
Outliers and viral hits: their videos on Overshot, all time.
Learn and practice dozens of Excel functions and tools online for free - from beginners to pro level, without the need to download any files.
All time.