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 !!
Thank you!
I should have said that I work with excel in spanish, therefore I need to understand the actual meaning of the functions MID, CHAR, REPT, » , to translate them in excel spanish syntaxis in order to execute the formula. Currently ASIS it is not working.
Regarding SUBSTITUTE, I need to complete 4 fields: text, original text, new text and nº of repetitions, but I imagine that this would be solved by entering the whole formula, once translated into spanish the four forementioned functions.
Sorry to be so dependant...
Thank you.
I added both to the attached file, just open it, function will be in your locale notation.
Merci infinimentSergeiBaklan !!