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)
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) […]