(no subject)

[serene]

Laugh if you want, but I'm enough of a geekophile that typing

=IF(ISBLANK(S7),(CONCATENATE(I7,"-",J7,"-",O7,P7,Q7,R7)),(CONCATENATE(I7,"-",J7,"-",O7,P7,Q7,R7,"-",S7)))

into a spreadsheet kinda gives me a little crush on myself. :-)

Comments

[cheshyre]

Not laughing, but wouldn't

=CONCATENATE(I7,"-",J7,"-",O7,P7,Q7,R7)&IF(ISBLANK(S7),"","-"&S7)

be more concise?

[Sorry if this is obnoxious, my first job out of college was tech support for Lotus 1-2-3. I still use spreadsheets as an all-purpose tool...]

[serenejournal.livejournal.com]

Not obnoxious at all. I didn't know how to do that; thanks!

[cheshyre]

There are several pages on my website, including my books-read lists, that are entirely generated from concatenated formulae in a spreadsheet.

I have actually run into maximum character limits while writing formulae, so I tend to look for the shorter option.

[serenejournal.livejournal.com]

Well, I really appreciate it; thanks again.

[bernmarx.livejournal.com]

=I7&"-"&J7&"-"&O7&P7&Q7&R7&IF(S7="","","-"&S7)

is shorter yet. :) Or wandering into the realm of geekiness for the sake of being geeky (not recommended practice):

=I7&"-"&J7&"-"&O7&P7&Q7&R7&REPT("-",D2<>"")&S7

(I had to check to make sure this would actually work. It does! :) )

[bernmarx.livejournal.com]

Uffda, that should have been

=I7&"-"&J7&"-"&O7&P7&Q7&R7&REPT("-",S7<>"")&S7

Oops. :)

[tom-allen.livejournal.com]

I had to paste that in to see what it does. I dont' use the text functions very often.

Oh.

You're cute.

[serenejournal.livejournal.com]

*twirl*

(Thanks!)

(For work, I need to create a product code by blending together a bunch of data the client has entered in different columns.)

[tiger-spot.livejournal.com]

Mmmm. You are not the only one. :)

[serenejournal.livejournal.com]

*beam* :-)

[hitchhiker.livejournal.com]

that's very cute :)

[papabearnz.livejournal.com]

I type similar stuff into my s/sheets at work (this is from memory so may not be completely accurate)

=if(error.level(g7)=7,vlookup(b7,Source!a,Source!c),"")

Not quite as geeky as yours but I couldn't remember the one that involved pulling a subsequence of data from a pivottable and comparing and ananlysing.