Category : Technology

    Home / Technology / Archive by category "tools"
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

16 March, 2010

Screenshots generators

Posted in : Technology, tools on by : admin

I really don’t know what happened to browsershots.org. It seems pretty dead, which is really sad since it was a great way to see how websites I worked, look on platforms I was not very likely to be accessing in RL. Oh, well. I found that Adobe is offering similar service (although not as extensive
Read more

19 October, 2009

Aack! .PUB files converter, A G A I N!

Posted in : tools on by : admin

I love figuring out  how to do stuff, but knowing I already figured something only a couple of months ago, went through some mind erasing phenomenon, and have to go through it again, just sucks! So here is the link to the online service: www.zamzar.com www.freepdfconvert.com Now, if only I had a way to remember
Read more