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), )
Category: tools
Flipping Typical saved the day
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), … Continue reading Flipping Typical saved the day
Vector Graphics to Social Media Icons
I really wanted to Facebook “like” this page, but ironically they don’t provide a link. So here is my own like link: icondock.com/free/vector-social-media-icons
Free Fonts Saved the Day
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… Continue reading Free Fonts Saved the Day
WordPress user registration plugin – where is the Typo3 counterpart?
I have spent a large portion of today fighting the good fight with Typo3. Typo3 won the battle. I am sure if I knew what I am doing it would have been an easy task, but since I am still fumbling with that CMS, it was very hard and didn’t yield anything like what I… Continue reading WordPress user registration plugin – where is the Typo3 counterpart?
Screenshots generators
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… Continue reading Screenshots generators
Aack! .PUB files converter, A G A I N!
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… Continue reading Aack! .PUB files converter, A G A I N!