Excel Formula to Remove Text after Specific Character

In this example, everything starting with the "?" is removed from text in cell B7:

=IF(ISNUMBER(FIND("?",B7)),LEFT(B7,FIND("?",B7)-1),B7)

Read More

Add Browser Toolbar Buttons: "Send to Blogger", "Add to Google Bookmarks" (Also "Wayback" and "Google Translate")

First, if you don't see Chrome's toolbar: CTRL + B

To add:

"Send to Blogger": Drag the BlogThis! text from here on blogger.com to the toolbar.

"Add to Google Bookmarks": Drag the Google Bookmark button from here on google.com to the toolbar.

Other cool toolbar add-on's:

Wayback (show the page’s revision history) - drag the Wayback button from here

Google Translate (show the page in English translation) - drag the text 'English' from here

! Big thanks to: Scrupuli: Send to (Blogger, Bookmarks, Mail, Wayback, English) in Google Chrome

Read More

How to Search across Multiple PDF Files

To search for text inside multiple PDF Files:

1. Open Adobe Reader.
2. Open Full Reader Search: SHIFT + CTRL + F.

Big thanks to: http://www.online-tech-tips.com/computer-tips/how-to-search-for-text-inside-multiple-pdf-files-at-once/

Read More

Add Google Bookmark Link to Chrome

URL:  javascript:(function(){var a=window,b=document,c=encodeURIComponent,d=a.open("http://www.google.com/bookmarks/mark?op=edit&output=popup&bkmk="+c(b.location)+"&title="+c(b.title),"bkmk_popup","left="+((a.screenX||a.screenLeft)+10)+",top="+((a.screenY||a.screenTop)+10)+",height=420px,width=550px,resizable=1,alwaysRaised=1");a.setTimeout(function(){d.focus()},300)})();



Thanks: http://www.google.com/support/chrome/bin/answer.py?hl=en&answer=100215

Read More

Add "Email a Link" to Chrome

Most browsers provide you with a way to easily email a link to the page you are currently viewing. When clicked, your default email application will produce a new message with the link in the body and the page title in the Subject line and the To field left blank for you to address. This functionality is missing from Chrome, but can easily added by creating a button on the Bookmarks bar.

Drag this link to your bookmarks bar: Send Link!.

Or if that doesn't work:

1. Open Chrome.

2. Right-click the Bookmarks bar and select Add Page.

3. In the Name textbox, input the word Send Link.

4. In the URL textbox, input the following:

javascript:location.href='mailto:?SUBJECT='+document.title+'&BODY='+escape(location.href);

5.Make sure that the Bookmarks bar folder is selected and click OK.

! Big thanks to: http://www.tech-recipes.com/rx/3024/google_chrome_add_send_link_button_to_bookmarks_bar/

Read More

Temporarily Disable Mcafee

How to temporarily disable Mcafee Security Center - CNET Spyware, viruses, & security Forums:

Double-click the taskbar icon to open the Security Center
Click Advanced Menu (lower left)
Click Configure (left)
Click Computer & Files (upper left)
VirusScan can be disabled on the right.

Do the same via Internet & Network for Firewall Plus.

Big thanks to: http://forums.mcafeehelp.com/showthread.php?t=213892

Read More

How to get a personalized FaceBook URL when they don’t offer one

Facebook is not yet enabling “vanity” URL for your profiles but they “hope to make these URLs available (…) in the future.”

Until then you can do this:

1. Click on “home” then click on “profile”, you should see a URL like this in your address field:
www.facebook.com/home.php#/profile.php?id=123456789&ref=profile
2. Now copy that number, in this example 123456789.
3. The public URL for your Facebook page is then:
www.facebook.com/people/FirstName-LastName/123456789

Put in your real first and last name in the above link and keep the hyphen as separator. Voila!

However, if you want to be found by people who are not on Facebook yet, you would have to first make your profile publicly searchable by going to Privacy Settings -> Search.

When you have your personal URL, make it trackable baby!
Hint: Case Sensitive, took me 10 minutes to figure that out!
http://bit.ly/JenHarris09FaceBook

I use bit.ly & I can’t tell you how it has made my online life justifiable! You can customize a shortened URL, place it ANYWHERE you want (wordpress, FaceBook, Twitter (duh), LinkedIn, Communities etc) for optimal tracking. So if you are using anything BUT bit.ly, re-think & think how smart you will look when you can say “and then we received 80% of our hits from ONE post, which led to an increase in sales that day for a 45% conversion rate “.

Just saying, makes you look cool!

! Big thanks to: http://caffeinatedmarketing.com/2009/04/06/personalize-your-facebook-url/

Read More

Ping to Test Internet Connection

To run a ping test on Windows:

1. Open the Command Prompt or MSDOS prompt dialog box (Start, Programs, Accessories, Command Prompt).
2. Type "ping www.verizon.net".
3. Press [Enter] (Note: Some computers will not respond to the ping test for security reasons. If a Web page or server doesn't respond to ping, try a different one.)

You have an active internet connection if you see results similar to this:

Reply from 206.46.189.11: bytes=32 time=40ms TTL=249

! Big thanks to: the comcast technician who was here today.

Read More

Remove Line in Word Document

To remove this “line,” select the paragraph above it and remove all the borders from it as follows:

In Word 2003 and earlier, go to the Format Borders and Shading dialog, and click the preset picture for “None.” Alternatively, click the down arrow beside the Borders button on the Formatting or Tables and Borders toolbar and choose the last (No Border) option in the palette.

In Word 2007, on the Home tab, locate the Paragraph group. The bottom right button is the Borders button; click the arrow beside it and select No Border.

In any version, you can simply click in the offending paragraph and press Ctrl+Q, which resets the paragraph formatting to the default for the style (which doesn’t include borders). This, however, will remove any other direct paragraph formatting as well as the border.

! Big thanks to: http://word.mvps.org/faqs/Formatting/CantGetRidOfLine.htm

Read More