Skip to content

Instantly share code, notes, and snippets.

@bstonedev

bstonedev/fav-excel-formulas.md

Last active July 11, 2020 04:16
Show Gist options
  • Save bstonedev/cd569622ba31fd18c2668e3707ca9cac to your computer and use it in GitHub Desktop.
Save bstonedev/cd569622ba31fd18c2668e3707ca9cac to your computer and use it in GitHub Desktop.
Download ZIP
Favourite Excel Formulas (Work In Progress)
Raw
fav-excel-formulas.md

TEXTJOIN

Combine text across a bunch of cells into one cell =TEXTJOIN("",TRUE,A2:A10)

EXCTRACT FIRST N NUMBER OF SENTENCES OUT OF STRING IN CELL

Replace 3 with the number of sentences you wish to extract. =TRIM(LEFT(A2,FIND("^",SUBSTITUTE(TRIM(A2)&".",".","^",3))-1))&"."

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment