I regularly get a block of data with 45 different entries in the first collum, repeated for each time a month appears in column 2. I wanted to split the data based on column value quickly and automatically The following VBA code from extendoffice.com worked well 1. Open the Microsoft Visual Basic for Applications window. […]
Category: spreadsheets
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
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) […]