← Home About Archive media diet Also on Micro.blog
  • Mini pry bars (~ 6inches) are great for the most random tasks. Today: cleaning dryer vent.

    → 2:42 PM, Dec 11
  • Yum!

    → 7:02 PM, Nov 23
  • Into the oven they go!

    → 4:38 PM, Nov 23
  • Making this Crusty European Style Hard Roll Recipe today. Forgot to photograph the starter from last night. But, here’s everything mixed together for the first rise.

    → 7:59 AM, Nov 23
  • Corduroy is a magnificent fabric.

    → 1:24 PM, Nov 20
  • Nilla Wafers = still delicious

    → 1:43 PM, Nov 9
  • The new yellow iPad looks amazing 💛 More color everywhere please!

    → 1:46 PM, Oct 18
  • The ratio in this four candy pack seems just a wee bit heavy on the butterfingers.

    → 11:28 AM, Oct 18
  • Moon on the mountain

    → 7:25 PM, Oct 6
  • New to Me Excel Function for Combining Cells

    Situation: you have multiple columns of excel data and you need to combine them together. You’d like to use a delimiter between each data element with a hyphen or maybe a space.

    For our example lets use a product SKU. You have STYLE, COLOR, SIZE and you’d like to combine them to make your SKU. The table looks like this:

    A B C D
    1 style color size sku
    2 BOB BLUE M

    Previously I would have populated cell D2 with on of these two formulas to the result I’m after, BOB-BLUE-M:

    • =(A2&"-"&B2&"-"&C2)
    • =CONCAT(A2,"-",B2,"-",C2)

    NEW TO ME TODAY, you can use:

    • =TEXTJOIN("-", TRUE, A2:C2)

    The first part of the formula is your delimiter. The TRUE is if you’d like to ignore empty cells or not, in this case we are. And the last section of formula is the cells you’d like to combine. Now you’re saying “but hey that’s more characters than the other two formulas”, and you’d be correct. But what if you have 10 columns of data? Let’s compare:

    • =(A2&"-"&B2&"-"&C2&"-"&D2&"-"&E2&"-"&F2&"-"G2&"-"&H2&"-"&J2)
    • =CONCAT(A2,"-",B2,"-",C2,"-",D2,"-",E2,"-",F2,"-",G2,"-",H2,"-",J2)
    • =TEXTJOIN("-", TRUE, A2:J2)

    🎵 The more you know 🌈

    → 12:29 PM, Sep 28
  • That one piece of furniture that is cronically problematic whenever you need to move it somewhere. Won’t fit up the attic stairs, only kinda fits in two rooms of the house. ✅ for today. Until next time old friend.

    → 8:46 AM, Sep 10
  • Just watched this chill video of a guy building a Kona Sutra. Apparently the entire channel is just zen videos of bike builds. ❤️

    → 7:24 PM, Sep 8
  • Obama portraits unveiled
    “her grace, her intelligence” ❤️

    → 3:27 PM, Sep 7
  • Mostly trying to distract myself today, it’s the 5yos first day of Kindergarten. I hope it’s going well 🤞

    → 10:02 AM, Aug 31
  • Finally cooling off, I can smell the brewery next door brewing through the open windows. Enjoying the small things!

    → 10:00 AM, Aug 31
  • note to self: If Safari is giving you a weird error and not letting you open up local HTML files, you have to go into system preferences and give safari full disk access.

    → 2:00 PM, Jul 12
  • I totally forgot about this and it’s so funny. Darth Vader doing the Tom Tom GPS commercial

    Source: A Complicated Profession

    → 8:23 PM, Jun 27
  • More of this please! vtdigger.org

    Dartmouth College nixes student loans

    → 5:04 PM, Jun 21
  • How many mini cupcakes equal a big cupcake? Is it three? I had three.

    → 3:19 PM, Jun 6
  • More spring flowers.

    → 10:43 PM, May 11
  • Daytime moon.

    → 3:45 PM, May 10
  • Fruit trees blooming

    → 6:44 PM, May 9
  • This spring, these flowers popped up in our yard and they make me very happy.

    → 7:52 PM, May 8
  • 🌟

    → 9:58 PM, May 7
  • My mowing helper today.

    → 8:47 PM, May 6
  • → 7:29 PM, May 5
  • Fun with the night light and heater.

    → 9:23 PM, May 4
  • Experimental macro pad.

    → 4:14 PM, May 3
  • Grey and blurry day.

    → 3:04 PM, May 2
  • Hardware for the play structure. This will take awhile.

    → 12:40 PM, May 1
  • Polestar O2 = a seriously good looking car!

    → 2:40 PM, Mar 2
  • Pretty sure this snowman would win the limbo contest.

    → 9:23 AM, Jan 20
  • I really enjoyed voting on these endless internet debates source: kottke.org/quick-lin…

    → 1:31 PM, Jan 10
  • After 4+ months there was finally veggie cream cheese at the grocery store!!!

    → 1:08 PM, Jan 2
  • RSS
  • JSON Feed
  • Micro.blog