Skip to content

Instantly share code, notes, and snippets.

@hansgafriedzal

hansgafriedzal/excel-substr.file.extension.txt

Created July 25, 2018 11:39
Show Gist options
  • Save hansgafriedzal/15be42a924a0ce9b9181db972c742f10 to your computer and use it in GitHub Desktop.
Save hansgafriedzal/15be42a924a0ce9b9181db972c742f10 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
excel-substr.file.extension.txt
=REPLACE(RIGHT(A1,5),1,SEARCH(".",RIGHT(A1,5)),"")
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment