Posts Tagged ‘excel’
Get the Last Word in Google Sheets Cell or Excel Cell
Here’s what you need to retrieve the last word (or the first) in Google Sheets cells or using Excel if that’s your preference. Get the Last Word in Google Sheets =TRIM( RIGHT( SUBSTITUTE( A1 ; ” ” ; REPT( ” ” ; 100 ) ) ; 100 ) ) but if you might have any trailing…
Read ArticleHow to merge multiple CSV-files into one with Mac OS X Terminal.app
Found this csv merge tutorial and it works great to merge csv files on mac into one file. An explanation and quick piece of code that will help you to simply merge large numbers of .csv files (or for that matter: any kind of text files) into one. I used it to merge multiple .csv…
Read Article