Make formula result a clickable link in Excel  



Zoom the font size for best readability  
Good Morning,  !
It's Monday, January 31, 2011

Gullible Warming has dropped down to -30.
The major highways are mostly bare, but town streets still have lots
of snow. Hiking down to main street and back was quite funny. 
Most of the sidewalks had been shoveled between snow falls
and had only 3 - 4 inches of snow, some were even bare.
But the street still has the last three snowfalls on it, packed in 
some areas, deep ruts in others. Would be just right for 
snowmobiles, and some were out and about.

Have FUN!
DearWebby


If you can help with the server cost
please donate what you can!
The most merciful thing in the world, I think, is the inability of the human mind to correlate all its contents. --- H. P. Lovecraft You probably wouldn't worry about what people think of you if you could know how seldom they do think. --- Olin Miller
Having passed the enlistment physical, Jon was asked by the doctor, "Why do you want to join the Navy, son?" "My father said it'd be a good idea, sir." "Oh? And what does your father do?" "He's in the Army, sir."
This Undeleter will securely and easily recover deleted files from your hard drives, flash drives, USB external drives, Zip drives, Firewire drives, digital camera cards, and more. This powerful recovery software can recover deleted files from just about any data loss scenarios. Is your data worth recovery?

Following some duty overseas, the officers at the Fort were planning a welcome home party and dance for the unit. Being an all male combat force, they decided to request coeds from some of the surrounding colleges to attend. The Captain called Vassar and was assured by the Dean that arrangements could be made to send over a dozen of their most trustworthy students. The Captain hesitated, then said, "Would it also be possible to send a dozen or so normal ones?"
Click through the picture to the large version.
If you like the Dear Webby Daily Humor Letter, please vote for it at the Ezine Finder: Thanks for your votes!

An INTERNATIONAL BONEHEAD AWARD goes to Darwin Brown, 42 in Denver, CO Truck stolen with owner sleeping in back DENVER (UPI) -- A Denver man who has been living in his pickup truck camper said he was shocked when he woke up to find someone stealing the vehicle with him still inside. Terry Bannick, 59, said he was sleeping in bed of his 1993 Ford F-150 when he woke up at about 1:30 a.m. MST Saturday. Bannick said a man started the truck, using keys Bannick had left in the ignition, and drove the vehicle around for about 2 1/2 hours. "I tried talking to him, but he wouldn't even look at me through the sliding rear-view window, Bannick said. "I said, 'Why are you taking my truck? Where are you going?'" Bannick said he called police on his cellphone but he was unable to give a good description of his location due to his restricted views of the road from the camper. "He could hear me talking to the police," Bannick said. "I don't know what was wrong with him." Police finally caught up with the truck just as it was running out of gas. Darwin Brown, 42, was arrested and charged with auto theft and marijuana possession. He was ordered held without bail.
From the Tech Support Pits: From: Merryl Re: make formula result a clickable link in Excel Dear Webby; I know how to make stuff I type into a cell a clickable URL, but that is klutzy and tedious. I need a way so that a formula can automatically generate the url from values in different locations, like basic URL, user name, and date. The instructor at the college says Excel can't do that, and anyway, that is beyond the scope of the course. A friend told me to ask dearWebby, so here I am. Merryl Dear Merryl Yes, sure Excel can do that, just not in one easy step. put a formula way over on the side, for example in colymn Z, to collect and concatenate the data into a URL. Copy that down to every cell in column Z. Then, in B2, where you want the clickable URL, put =(HYPERLINK(Z2,">>") Copy that down into every cell on column B, and it will show clickable URLs in every one of them. Have FUN! DearWebby
Reset your Windows Password if you forgot or accidentally changed it. No need to re-install Windows or an expensive service call, IF you can find a tech willing to do it without calling the cops about a potentially stolen computer. RoboForm is great, once you are booted up. This program takes care of the boot-up password, so that you CAN get to RoboForm and all your other passwords. YOUR memory might be perfect, and YOU might never make a mistake, but if somebody in your house is not quite as perfect as you are, then better get the Password Resetter

A lady is having a bad day at the roulette tables in Las Vegas. She's down to her last $50. Exasperated, she exclaims, "What rotten luck! What in the world should I do now?" A man standing next to her, trying to calm her down, suggests, "I don't know... Why don't you play your age?" He walks away. Moments later, his attention is grabbed by a great commotion at the roulette table. Maybe, she won! He rushes back to the table and pushes his way through the crowd. The lady is lying limp on the floor, with the table operator kneeling over her. The man is stunned. He asks, "What happened? Is she all right?" The operator replies, "I don't know. She put all her money on 29. When 36 came up, she just fainted!"
Daily tip from Thriftyfun.com Keep Butter from Burning Often while sauteing, my butter easily burns. To prevent this I add a small amount of oil to the mixture. By Sandy from Graettinger, IA http://www.thriftyfun.com/ Check out ThriftyFun's Blog at http://www.myfrugallife.com Thriftyfun.com also has a newsletter. If you want more than just one tip per day, or if you want to share your tips, then you can subscribe to it here:ThriftyFun Highly recommended! If you like the ThriftyFun.com list, you can vote for it here:
Fred was in the hospital after a bad accident. He was in stable condition and expected to recover soon, but relatives from far and near were there visiting him. When the pastor heard about that he decided to pop in and get re-aquainted with them all. As the preacher stood next to the bed, Ol' Fred's condition appeared to deteriorate suddenly and he frantically motioned for something to write on. The pastor lovingly handed him a pen and a piece of paper, and Ol' Fred used his last bit of energy to scribble a note, then suddenly died. The preacher thought it best not to look at the note at that time, so he placed it in his jacket pocket. At the funeral, as he was finishing the message, he realized that he was wearing the same jacket that he was wearing when Ol' Fred died. He said, "You know, Ol' Fred handed me a note just before he died. I haven't looked at it, but knowing Fred, I'm sure there's a word of inspiration there for us all. We'll let his widow read to us the last words Fred had for us." And with that he handed the note to Fred's widow. She opened the note, and read, "Please step back. You're standing on my oxygen tube!"
Ophelia Dingbatter's News
No sermon and not suitable for church, just jokes and fun for grownups. Read it on-line or subscribe. If you subscribe, look for the double-opt-in confirmation request.
Three Jewish mothers are sitting on a park bench in Miami Beach talking about how much their sons love them. Sadie says, "You know the Chagall painting hanging in my living room? My son, Aaron, bought that for me for my 75th birthday. What a good boy he is, and how much he loves his mother." Minnie says,"You call that love? You know the Eldorado Cadillac I just got for Mother's Day? That's from my son Bernie. What a doll." Shirley says, "That's nothing. You know my son Stanley? He's in analysis with a psychoanalyst on Park Ave. Five session a week. And what does he talk about every session? Me."

Funny Fishing





[ view entry ] ( 138 views )   |  permalink  |  print article  |   ( 3 / 741 )

<<First <Back | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | Next> Last>>