by Sanat Kumar on August 3, 2010
Wondering how to be offline or invisible with Google Talk while being online!!!
Google Talk, Labs Edition is the answer…
It has got nice interface and common feature like group chat, emoticons. In this edition, it has tabbed chatting which reminded me of icq chatrooms.
Enable your notification settings to get notified when someone writes a scrap. or when an email arrives or if you have an appointment which is stored in your google calendar. If you heavily rely on google calendar, it also has an snooze option.
Download Google Talk, Labs Edition
*Currently, google talk labs edition doesn’t have voice calling and file transfer.
*Works only on Windows.
by Sanat Kumar on April 26, 2010
Here’s a short little time saver if you’re working on a old database website or editing links for SEO purposes. What we are trying to achieve here is, Editing/Renaming links and save time through Excel using formula.
In all four methods Column A, Column C & Column E will remain constant.
- Column A : <a href=”
- Column B : Filename
- Column C : .html”>
- Column D : Text-Link
- Column E : </a>
- Formula Used : EQUAL TO, CONCATENATE
“EQUAL TO” formula copies the exact text from a certain cell. In this case, we have used formula in Cell D2(=B2) and D3(=B3) to copy the text from Cell B2 and B3 respectively. So if you have links which have the same filename’s as links, you can use this. In the end you can join all the columns into a string using “CONCATENATE”. The function would be “=CONCATENATE(A2,B2,C2,D2,E2)”. You can see the final output in Cell A6 & A7.
- Formula Used : UPPER, CONCATENATE
In this case we have CAPITALIZED the text link only, rest remains the same. So the formula function for D2 will be “=Upper(B2)” and “=Upper(B3)” for D3.
- Formula Used : SUBSTITUTE, CONCATENATE
Here, we have used the SUBSTITUTE function to remove the dashes between the filename and have replaced it with spaces.
So the formula function would be, “=SUBSTITUTE(cell,text you wanna replace,text to replace with)” . In this case, D2 function would be =SUBSTITUTE(B2,”-”,” “)
#Seo-Tip : If you keep the title of the file-name and text-link same, you can get a better SEO score for your pages.
- Formula Used : PROPER, CONCATENATE
PROPER function capitalizes the first letter of every word. The function for D2 will be “=PROPER(B2)”.
Equal TO : “=Cell”
UPPER : “=UPPER(Cell)”
SUBSTITUTE : “=SUBSTITUTE(Cell,Text you wanna replace,Text to replace with)”
PROPER : “=PROPER(Cell)”
CONCATENATE : “=CONCATENATE(Combine Cell)”
You can also make your links bold<b> and italics<i> by simply adding few more columns and combine them using Concatenate.
