=REPLACE(RIGHT(A2,5),1,SEARCH(".",RIGHT(A2,5)),"") into a blank cell besides your data. To extract the file extensions from the cells, the following formula can do you a favor.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |