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

• About
• Latest Posts

Rae Allen

Rae Allen is a digital media professional.

Latest posts by Rae Allen (see all)

• Street art – November 23, 2024 at 11.44AM – 27/11/2024
• Street art October 26, 2024 at 12:10PM – 26/10/2024
• Street art October 26, 2024 at 09:31AM – 26/10/2024