Category: Software
Turning Text into Excel Formulas
A reader asks:
"I have a Microsoft Excel 2003 spreadsheet in which I need to build a formula from text found in different cells, then evaluate that formula. For a simple example, suppose the cell contained "=SQR" & "T(25)"-that should evaluate to the square root of 25, or 5. Building the formula by concatenating text strings is no problem, but how do I tell Excel to evaluate the formula?"
For the solution, go here.
For more Solutions, go here.
For more useful tips, check www.pcmag.com/tips (and scroll down to search Tips by category).
CES: More News From the Show Floor
Here are some highlights:
E-mail askneil@ziffdavis.com for questions about operating systems or software.
E-mail askloyd@ziffdavis.com for questions about hardware.
E-mail ZDI_Subscriptions@ziffdavis.com for questions about your newsletter subscription.
 |
SUBSCRIBE TO PC MAGAZINE AND SAVE 82%
Subscribe today and save 82% off the newsstand price. Plus, you will receive FREE software from PC Magazine with your subscription. Don't miss this limited time offer.
PC Magazine is America’s #1 technology magazine, delivering
authoritative, lab-based comparative reviews of technology products and
services to more than 6.6 million professionals every issue.
|
To find out more about what's going on in the world of technology, check out www.pcmag.com throughout the day!
ADVERTISEMENT
|
 The PCMag.com Bookstore
PC Magazine's Windows Vista Solutions
We've got all the answers you need to get the most out of Microsoft's new OS. In our Windows Vista Solutions book, we'll help you pick the right version of Vista, optimize it for maximum security and/or flexibility, and configure it to suit your work habits. Also, learn about new features and applications like Windows Photo Gallery, Media Player 11, and Internet Explorer 7.
PC Magazine's Office 2007 Solutions
Want to get the most out of your new Office suite? Struggling to make sense of the Ribbon? Let PC Magazine show you how with our Office 2007 Solutions book, with tips and shortcuts for the apps you use the most during your workday: Word, Excel, PowerPoint, and Outlook. Learn how to safely install the suite and keep it up to date, integrate it with Windows Vista, and use even the most advanced features.
More Books
eNewsletter Information
You are subscribed to PC Magazine Tip of the Day with the email address kallyorama@gmail.com.
Click here
to *** from this newsletter.
To subscribe to other e-mail newsletters
from Ziff Davis, change your delivery format from HTML to text, or change
your email address, click here.
Copyright © 2008 Ziff Davis Media, Inc. All Rights Reserved.
Ziff Davis Media Inc., 28 East 28th Street, New York, NY 10016
|
|
FEATURED VIDEO
|
Got a fabulous new HD TV for the holidays? Well, don't watch the same old boring SD content! Our expert Robert Heron will tell you the top sources for HD content.
More Videos>> |
PCMAGAZINE UTILITY DOWNLOADS
PARTNER SPOTLIGHT
Find the ThinkPad that fulfills your business requirements! Click here today!
Special Offers Now on Thinkpad® and Lenovo 3000 PCS.
Save Now >
Free White Paper:
A Smart Server Strategy for Small and Mid-Sized Businesses
Learn More!
|
Back to newsletter list
