alexandros6600
New Member
Hi all,
in the attached excel file, in column A are a mixed format of texts and numbers i want to extract.
By which formula can i extract ONLY the numbers that end with the letter T
Example from A1 i want to extract only the Number 100 from the 100T in cell Β1
Thank you in advance
in the attached excel file, in column A are a mixed format of texts and numbers i want to extract.
By which formula can i extract ONLY the numbers that end with the letter T
Example from A1 i want to extract only the Number 100 from the 100T in cell Β1
Thank you in advance