Category : Technology

    Home / Archive by category "Technology"
1 June, 2015

Excel inline commands I use often

Excel inline commands I use often
Posted in : Technology, tools on by : admin
Tags:

Concatenate three cells into one separated with a comma (trim trailing space and commas): =IF(TRIM(J2)=””,IF(TRIM(I2)=””,H2, TRIM(H2&”, “&I2)),TRIM(H2&”, “&I2&”, “&J2) ) Concatenate two cells into one separated with a comma (trim trailing space and commas): =IF(TRIM(L2)&TRIM(K2)=””,””,IF(TRIM(L2)=””, IF(TRIM(K2)=””,””,TRIM(K2&”, “&L2), )

11 June, 2013

Flipping Typical saved the day

Flipping Typical saved the day
Posted in : Technology, tools, user interface on by : admin

I am not sure what causes Adobe suite to go bonkers when I try to change my typed text’s fonts. I suspect it has to do with the insane amount of fonts I have accumulated in a few different languages. I found: flippingtypical.com It lets you preview all (most/more than Photoshop/Illustrator are will to deal with), 
Read more

9 February, 2011

Free Fonts Saved the Day

Posted in : Technology, tools, user interface on by : admin

I was trying to match a font on a banner on one of the websites I work on. First I tried to identify the font by submitting the image to MyFonts’ WhatTheFont tool, but that gave me less satisfactory results. At that point I used the identifontsite by answering questions about the text available on
Read more

21 January, 2011

My Unix Commands

Posted in : programming, unix on by : admin

Find text within files in sub directories find . -type f -exec grep -il “text string” {} ; Change the photo files name: for f in 100_*.jpg; do mv $f ${f/100_/p}; done Add an ‘s’ to thumbnail: for f in p*.jpg; do mv $f ${f/./s.}; done List all files including sub directories into file ‘a.txt’:
Read more