Have arrived in Berlin, met Florian, bought some food and slept after 30 plus hours of travel
http://bit.ly/1l3zPFR
Year: 2014
-
-
Berlin 2 floor roof-top apartment in Berlin
Berlin 2 floor roof-top apartment in Berlin
This is the apartment we have booked for our month in Berlin
http://bit.ly/1iyZMWK -
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) returns the length of the string in cell A1: 19 letters in Australia: Brisbane
- It then subtracts 11, in order to leave out the first 11 characters: Australia plus the colon plus the space
- Then RIGHT() takes the last 8 letters from the string and returns: Brisbane
- In effect, this has removed the first 11 characters of the string