Forum Discussion
Solved
Extract a date from a cell
I used an excel sheet to create flashcards. In each cell, there are 4 "lines" (tabulated with Alt + Enter) and I need to select the 3rd "line", exclusively made of numbers: a year (1550) or a range ...
Merci infinimentSergeiBaklan !!
Use the SPLIT() function. 🙂
=INDEX(FILTERXML("<y><z>"&SUBSTITUTE(A1,CHAR(10),"</z><z>")&"</z></y>","//z"),3)=INDEX(FILTRE.XML("<y><z>"&SUBSTITUE(A1;CAR(10);"</z><z>")&"</z></y>";"//z");3)