Skip to content
  • RaeAllen.net
  • Portfolio
  • Photos
  • Presentations
  • Video
  • About

RaeAllen.net

a collection of sorts

Asides

Spreadsheet formulas: Remove characters from the right

26/03/2014 Rae Allen Leave a comment

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

Read More →

development, spreadsheets excel, formula, spreadsheet
RaeAllen.net

Archive

January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« May    

Categories

Tags

Amazon amonthinberlin art article audio beer berlin brücke brückemuseum charlottenberg coffee courtyard craftbeer education excel Flickr formula friedrichshain gallery gesundbrunnen graffiti grunewald IFTTT Instagram kreuzberg lyrics memorial mitte mural museum poetry Prenzlauer Rae Allen's Customer Reviews repost sculpture streetart train training u2 ubahn video wedding wp zehlendorf zen

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
January 2021
M T W T F S S
 123
45678910
11121314151617
18192021222324
25262728293031
« May    

Categories

  • audio (25)
  • development (23)
    • HTML5 (1)
    • spreadsheets (3)
    • xssi (3)
  • g+ (102)
  • Interesting Articles (5)
  • Manuals (1)
  • minutiae (4)
    • trivia (1)
  • music (30)
    • lyrics (27)
  • obits (1)
  • photo (63)
    • flickr (35)
  • poetry (45)
    • australian (13)
  • portolio (47)
  • presentation (5)
  • quote (44)
    • anon sayings (11)
  • reading (26)
    • drama (4)
  • recipe (21)
  • sci-fi (4)
  • social (3)
  • training (22)
  • Travel (71)
    • Berlin (71)
  • tv (32)
    • ABC-TV (30)
  • Uncategorized (39)
  • video (42)
  • wandering (7)
  • work (4)
  • zen (170)
    • koan (164)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
Designed by Atanas Yonkov || Powered by WordPress