EXCEL - EXTRAIRE DU TEXTE PEU IMPORTE SA POSITION ET SA TAILLE (Combiner formules STXT et CHERCHE)

📩 Download the Excel file for this video for free here: https://cours.excel-en-ligne.fr 🚀 Master the full power of Excel in just 6 weeks with Excelsior (eligible for the CPF): https://excel-en-ligne.fr/excelsior/ ▬▬▬ 📝 VIDEO SUMMARY ▬▬▬▬▬▬▬ In this video, I explain how to extract part of the text contained in a cell in Excel. = The goal is to be able to extract text with several constraints: The text to be extracted is never located in the same position (in the character string) from one cell to another. The text to be extracted has a variable length from one cell to another. We can circumvent these two constraints by combining the STXT and SEARCH formulas: STXT formula: Allows you to extract the number of characters of your choice from a string, starting from a location you specify. SEARCH formula: Searches for a text string within a cell and returns the starting position number (from the first character) of the searched text in the cell in which the text is being searched. = Therefore, the SEARCH formula will allow us to find the starting position of the text to be extracted using the STXT formula. = We'll look at several examples of text extraction from strings: Extracting the patient number (Example: Num1411b) Extracting the registration number (Example: AX-158-LM) Extracting a variable-length data set = Department number, City (variable-length data), and date of birth (Example: 69LYON29/12/1992) = It's only by combining the STXT and SEARCH formulas that we can solve all these cases: that is, extracting text regardless of its location in the cell and regardless of its size. ----------------------------------------------------------------------------- #Excel #ExcelFormula #ExcelTraining ► Website: https://excel-en-ligne.fr/ ► Facebook:   / axelrobinformations   EXCEL - EXTRACT TEXT REGARDLESS OF ITS POSITION AND SIZE (Combine STXT and SEARCH formulas):    • EXCEL - EXTRAIRE DU TEXTE PEU IMPORTE SA P...