Office Hackery

Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to check if a Cell contains a Text in MS Excel

No comments
Its been a while since my last excel tip. Today on my way at the office, I received a call from by brother jayson.

foxtrot: Hello?
Jayson: Kuya, Im doing this excel for my boss and I need to know How to check if a cell contains a text or number?

Excel can easily determine if a particular cell contains text using the IsText function which returns TRUE or FALSE. Here is an example:


=IsText(A1)

If A1 contains a text then it will return TRUE, otherwise it will display FALSE.

You can also beautify the displayed result by using IF statement. For example:


=IF(IsText(A1),"Cell contains Text","Cell contains no Text")

Instead of TRUE or FALSE, the formula above will return a pre-define text display.

No comments :

Post a Comment

Get Your User Manual Online

No comments
While looking for my Nikon D40 User manual on its old box, I found it missing. I really need it badly because I was about to sell it but the buyer requires the manual be included. Fortunately, I found a way to download a copy of the original User Manual at TheManualsonlineSite.com. The site ManualsOnline help you locate hard-to-find user manuals, discover new features, and realize the potential of the products you rely on. ManualsOnline pairs self-help and product information with a growing community of engaged product owners.

To find the User Manual your looking for, you just need to Enter the Manufacturer Name and Model Number then click Search button. Or you can browse from its user friendly menu.

Here's a screenshot of the Nikon D40 User Manual I found.

The User Manual Online Search

No comments :

Post a Comment

Computer Hardware Chart

1 comment
This morning I found this useful chart where most computer parts are listed. So if you are a beginner or simply want to identify what part of the computer your looking for, you must have this tool.

Computer Hardware Chart

Click here to view the actual size of the Computer hardware poster 1.7 [deviantART]

1 comment :

Post a Comment

Free software to create photo mosaics

No comments
Free software to create photo mosaicsWhenever I see photo mosaic, all I can think of is how hassle was the creation process for the person created it. But in contrary mosaic creation can be as easy as counting 1, 2 3. This is of course with the use of a freeware called Foto-Mosaik-Edda. Foto-Mosaik-Edda is freeware (this means you don't have to pay for it) that can create mosaic-pictures that are composed of many small pictures (tiles), from your own photos.

To use it you need to specify the directory of your images (recommended number is 2000 or more) and it'll scan through and create a base set of "tiles" for your mosaic (it can take minutes to finish). Once all pictures are scanned, you can pick your primary photo to be the mosaic image.

Here are some screenshots of the Foto-Mosaik-Edda.

Foto-Mosaik-Edda Mosaic Creation

Finish Mosaic Picture

Download this cool software via sixdots.

This article is re-posted from Fryan0911.com

No comments :

Post a Comment

Free online OCR scanning

2 comments
My friend went to my apartment last night because his PC broke down. He brought a 100+ pages bonded document with him. He was about to type all the text on this document when I suggest an easier way to do it. Instead of typing it all, we scanned the pages and uploaded each page to Free OCR.

Free OCR is a free online OCR (Optical Character Recognition) tool that enables you to extract text from an image and convert it into an editable text document.

Free online OCR scanning

Read more about Free online OCR via [fryan0911]

2 comments :

Post a Comment