Mastodon

Aside – RaeAllen.net
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

May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Aug    

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
May 2022
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Aug    

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 (23)
    • soup (1)
  • sci-fi (4)
  • social (3)
  • training (22)
  • Travel (71)
    • Berlin (71)
  • tv (32)
    • ABC-TV (30)
  • Uncategorized (40)
  • 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