Tag: spreadsheet

Spreadsheet formulas: Prepend by concatenation

Post author By Rae Allen
Post date 29/06/2016
Categories In development, spreadsheets
No Comments on Spreadsheet formulas: Prepend by concatenation

Have had to delve into some formulas for processing text files so needed someplace to jot them down Prepend the word GET and a space to front of a string by the concatenation method =CONCATENATE(“GET “,B1)

Spreadsheet formulas: Remove characters from the right

Post author By Rae Allen
Post date 26/03/2014
Categories In development, spreadsheets
No Comments on Spreadsheet formulas: Remove characters from the right

Have had to delve into some formulas for processing text files so needed someplace to jot them down Remove 11 characters from the right of the string in a cell: =RIGHT(A1, LEN(A1)-11) How does this work? Le’s say you have a number of locations with Australia at the start, e.g. Australia: Brisbane, Australia: Sydney LEN(A1) […]