document.write('<div class="feedburnerFeedBlock" id="microsoft/NsYF6c01vh6e0kto73p60qejh1el0s">');
document.write('<p class="feedTitle">Text Functions</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/260893" target="_blank" >Works: Spreadsheet Functions Imported from Excel 2000 to Works</a></span>');
document.write('<div>Functions that return a text string have their last return value imported as text. Functions that return decimal numbers have their last return value imported as decimal.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/eDLpYwjgDdLoikiTTcYZsnfsLIM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/eDLpYwjgDdLoikiTTcYZsnfsLIM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/eDLpYwjgDdLoikiTTcYZsnfsLIM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/eDLpYwjgDdLoikiTTcYZsnfsLIM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/205548" target="_blank" >How to use A functions in Excel</a></span>');
document.write('<div>Text and logical values are ignored by the MIN and MAX functions. Using the example data in the AVERAGEA and AVERAGE section, consider the following formulas:\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/a1Hv4Q2qFWORhLz1QSKNMWlroxU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/a1Hv4Q2qFWORhLz1QSKNMWlroxU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/a1Hv4Q2qFWORhLz1QSKNMWlroxU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/a1Hv4Q2qFWORhLz1QSKNMWlroxU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/828103" target="_blank" >Differences between the Excel statistical functions STDEVPA and STDEVP</a></span>');
document.write('<div>STDEVP ignores blank cells and cells that contain TRUE, FALSE, or a text string. These interpretations also apply for the COUNT, AVERAGE, and STDEV functions.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/G5CZiBvvuj-X-8i2_t34YVVjMuY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/G5CZiBvvuj-X-8i2_t34YVVjMuY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/G5CZiBvvuj-X-8i2_t34YVVjMuY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/G5CZiBvvuj-X-8i2_t34YVVjMuY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/263580" target="_blank" >How to change the case of text in Excel</a></span>');
document.write('<div>Describes how to use worksheet functions to modify the case of text in Excel. Provides an example.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/hFG-nrG9oesMrdhp1hw9cdmEhS0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/hFG-nrG9oesMrdhp1hw9cdmEhS0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/hFG-nrG9oesMrdhp1hw9cdmEhS0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/hFG-nrG9oesMrdhp1hw9cdmEhS0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/156445" target="_blank" >XL97: New A Functions in Microsoft Excel 97</a></span>');
document.write('<div>Text and logical values are ignored by the MIN and MAX functions. Using the example data in the AVERAGEA and AVERAGE section, consider the following formulas.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1Q5xUx-BEL982-Zn3t0jW0QAzpw\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1Q5xUx-BEL982-Zn3t0jW0QAzpw\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1Q5xUx-BEL982-Zn3t0jW0QAzpw\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1Q5xUx-BEL982-Zn3t0jW0QAzpw\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/188075" target="_blank" >How to Find Secant, Cosecant, or Cotangent of an Angle</a></span>');
document.write('<div>and then double-click the selected text to go to the \"About math and trigonometry functions\" topic. If you are unable to find the information you need, ask the Office Assistant.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/XcGHfWcM3oom576WRP5NESy0GNk\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/XcGHfWcM3oom576WRP5NESy0GNk\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/XcGHfWcM3oom576WRP5NESy0GNk\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/XcGHfWcM3oom576WRP5NESy0GNk\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/812315" target="_blank" >MACXL: How to Change the Case of Text</a></span>');
document.write('<div>This article describes how to use worksheet functions to change the case of text.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/mU5Hkq2-8xWJLX1BlchJMdRXVws\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/mU5Hkq2-8xWJLX1BlchJMdRXVws\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/mU5Hkq2-8xWJLX1BlchJMdRXVws\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/mU5Hkq2-8xWJLX1BlchJMdRXVws\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/181709" target="_blank" >XL98: New A Functions in Microsoft Excel 98 Macintosh Edition</a></span>');
document.write('<div>Text and logical values are ignored by the MIN and MAX functions. Using the example data in the AVERAGEA and AVERAGE section, consider the following formulas.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1HskylObx-lNlOnPMzCgZhC4A8w\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1HskylObx-lNlOnPMzCgZhC4A8w\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1HskylObx-lNlOnPMzCgZhC4A8w\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1HskylObx-lNlOnPMzCgZhC4A8w\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/108280" target="_blank" >Function to compute average without high and low values</a></span>');
document.write('<div>and then double-click the selected text to go to the \"About user-defined functions\" topic.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/P_uBxrV6HZ7A7FCUdrJvsRaaYio\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/P_uBxrV6HZ7A7FCUdrJvsRaaYio\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/P_uBxrV6HZ7A7FCUdrJvsRaaYio\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/P_uBxrV6HZ7A7FCUdrJvsRaaYio\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/129073" target="_blank" >TEXT(MONTH(NOW()),\"mmm\") Always Returns \"Jan\"</a></span>');
document.write('<div>When you nest the TEXT(), MONTH(), and NOW() functions as in the following example Microsoft Excel will always return the result \"Jan\".\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/CLMR0kKx93P9bBRfwW1kkSDNObs\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/CLMR0kKx93P9bBRfwW1kkSDNObs\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/CLMR0kKx93P9bBRfwW1kkSDNObs\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/CLMR0kKx93P9bBRfwW1kkSDNObs\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/200855" target="_blank" >XL98: Unexpected Results with Mixed Text and Numbers in Lookup Table</a></span>');
document.write('<div>After you create a lookup table, you may experience either of the following symptoms: Lookup functions on a worksheet may return the #N\/A error value. -or- Lookup functions in a ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/LoFQuolIW-t0xrj6RLh8raxREAI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/LoFQuolIW-t0xrj6RLh8raxREAI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/LoFQuolIW-t0xrj6RLh8raxREAI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/LoFQuolIW-t0xrj6RLh8raxREAI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213646" target="_blank" >How to use the left, right, mid, and len functions in Visual Basic for ...</a></span>');
document.write('<div>This article contains examples of how to manipulate text strings using the Left, Right, Mid, and Len functions in Microsoft Visual Basic for Applications in Microsoft Excel.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/o_960y2cBYTWtWafaWRmJaR-KjM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/o_960y2cBYTWtWafaWRmJaR-KjM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/o_960y2cBYTWtWafaWRmJaR-KjM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/o_960y2cBYTWtWafaWRmJaR-KjM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/75945" target="_blank" >How to Convert Text to Numbers in Excel</a></span>');
document.write('<div>This will cause functions such as SUM() and AVERAGE() to ignore the values in these cells. These text strings may contain actual text in addition to the numbers you want to ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/iLi2WghC4tF7lWuru962lDsEJVQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/iLi2WghC4tF7lWuru962lDsEJVQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/iLi2WghC4tF7lWuru962lDsEJVQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/iLi2WghC4tF7lWuru962lDsEJVQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/212013" target="_blank" >XL2000: Calculation of Formula in Formula Bar Returns #VALUE!</a></span>');
document.write('<div>... you select the formula in the formula bar and press F9, the formula returns #VALUE! instead of a string that contains 1000 \"a\" characters as expected. The following text functions ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4GmJhtARa81BPzs7Vdg_IwwS7Z8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4GmJhtARa81BPzs7Vdg_IwwS7Z8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/4GmJhtARa81BPzs7Vdg_IwwS7Z8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/4GmJhtARa81BPzs7Vdg_IwwS7Z8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/166461" target="_blank" >XL97: ROW And COLUMN Functions Are Not Recalculated</a></span>');
document.write('<div>For more information about writing custom functions, click the Index tab in Visual Basic for Applications Help, type the following text\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/neCYS_D5HbqdMMKq60V8a6GGFVQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/neCYS_D5HbqdMMKq60V8a6GGFVQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/neCYS_D5HbqdMMKq60V8a6GGFVQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/neCYS_D5HbqdMMKq60V8a6GGFVQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/59482" target="_blank" >Using INDEX and MATCH Against Multiple Criteria</a></span>');
document.write('<div>and then double-click the selected text to go to the \"About lookup and reference functions\" topic. \"User\'s Guide 1,\" version 4.0, pages 132, 138\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/3AI9DmqPKyMAY2AfjWZNYNP1mOY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/3AI9DmqPKyMAY2AfjWZNYNP1mOY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/3AI9DmqPKyMAY2AfjWZNYNP1mOY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/3AI9DmqPKyMAY2AfjWZNYNP1mOY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/167188" target="_blank" >XL97: Page Fault Using Formula Containing Boolean Functions</a></span>');
document.write('<div>For more information about using logical functions in formulas, click Contents And Index on the Help menu, click the Index tab in Microsoft Excel 97 Help, type the following text ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/f5uJlFlZXkjwYWT2SD_PfbJDsZM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/f5uJlFlZXkjwYWT2SD_PfbJDsZM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/f5uJlFlZXkjwYWT2SD_PfbJDsZM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/f5uJlFlZXkjwYWT2SD_PfbJDsZM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213429" target="_blank" >XL2000: TEXT(MONTH(NOW()),\"mmm\") Always Returns \"Jan\"</a></span>');
document.write('<div>When you nest the TEXT(), MONTH(), and NOW() functions as in the following example =TEXT(MONTH(NOW()),\"mmm\") Microsoft Excel will always return the result \"Jan.\"\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWYuoCax8wYjyEy61CcFl0a0N4I\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWYuoCax8wYjyEy61CcFl0a0N4I\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWYuoCax8wYjyEy61CcFl0a0N4I\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWYuoCax8wYjyEy61CcFl0a0N4I\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/161120" target="_blank" >Using a Worksheet Function in a Visual Basic Macro</a></span>');
document.write('<div>and then double-click the selected text to go to the \"List of Worksheet Functions Available to Visual Basic\" topic.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWGDJiwL6Xl-CzMORWZ8iT5XxHc\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWGDJiwL6Xl-CzMORWZ8iT5XxHc\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWGDJiwL6Xl-CzMORWZ8iT5XxHc\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/rWGDJiwL6Xl-CzMORWZ8iT5XxHc\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/158540" target="_blank" >XL97: Results Do Not Change After Toggling Transition Formula ...</a></span>');
document.write('<div>Earlier versions of Microsoft Excel treat text values that are arguments as zero, FALSE as 0 (zero) and TRUE as 1 (one) for these functions when the Transition Formula Evaluation ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/JQNKCmk9VTgsXaX6R_F1u-wyxBM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/JQNKCmk9VTgsXaX6R_F1u-wyxBM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/JQNKCmk9VTgsXaX6R_F1u-wyxBM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/JQNKCmk9VTgsXaX6R_F1u-wyxBM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214289" target="_blank" >Description of ODBC add-in functions and arguments in Excel 2000</a></span>');
document.write('<div>Lists functions that are provided by the Xlodbc.xla ODBC add-in. The ODBC add-in lets you ... use to separate the elements in column_delimiter each row of the created text ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/ab2VPxQ_qIF9GyGsyhE70smGGKA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/ab2VPxQ_qIF9GyGsyhE70smGGKA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/ab2VPxQ_qIF9GyGsyhE70smGGKA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/ab2VPxQ_qIF9GyGsyhE70smGGKA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/180374" target="_blank" >XL98: Results Do Not Change After Toggling Transition Formula ...</a></span>');
document.write('<div>The calculation behavior of these functions has changed in Microsoft Excel 98 Macintosh Edition. These functions ignore text values and logical values that are arguments even ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tDRtNmVnR8LyeKGs0RhF7mUnEYI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tDRtNmVnR8LyeKGs0RhF7mUnEYI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/tDRtNmVnR8LyeKGs0RhF7mUnEYI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/tDRtNmVnR8LyeKGs0RhF7mUnEYI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/113261" target="_blank" >Unexpected Results with Mixed Text and Numbers in Lookup Table</a></span>');
document.write('<div>In Microsoft Excel 7.0 and earlier, when you create a lookup table, the lookup functions may return the #N\/A error value, or, if you are using the functions in a Microsoft Visual ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/lMNAwZpZNhJpsDLONoD9QL9d3ho\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/lMNAwZpZNhJpsDLONoD9QL9d3ho\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/lMNAwZpZNhJpsDLONoD9QL9d3ho\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/lMNAwZpZNhJpsDLONoD9QL9d3ho\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/843504" target="_blank" >Description of the undiscovered tips about Excel</a></span>');
document.write('<div>On the Data menu, click Text to Columns. In step 1 in the Text Import Wizard, click ... The formula uses nested IF functions for each cell in the range and adds one to the ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1nxZ2VMo2z1iWIhXlGU2jMLfe4s\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1nxZ2VMo2z1iWIhXlGU2jMLfe4s\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1nxZ2VMo2z1iWIhXlGU2jMLfe4s\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1nxZ2VMo2z1iWIhXlGU2jMLfe4s\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/291323" target="_blank" >Sample macro code to change the case of text in Excel</a></span>');
document.write('<div>Although Microsoft Excel has functions that change the case of text, there are times when you may want to change text case programmatically. This article contains three sample ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/TiLrqc79WBzD8ahDHPsatbidqFU\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/TiLrqc79WBzD8ahDHPsatbidqFU\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/TiLrqc79WBzD8ahDHPsatbidqFU\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/TiLrqc79WBzD8ahDHPsatbidqFU\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/188082" target="_blank" >XL98: How to Find Secant, Cosecant, or Cotangent of an Angle</a></span>');
document.write('<div>Microsoft Excel 98 Macintosh Edition has built-in functions for a large number of ... earlier than 8.0), click the Index button in Excel Help, type the following text\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/WN5APnPVnPKeDrsZu-3hLSV1_kQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/WN5APnPVnPKeDrsZu-3hLSV1_kQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/WN5APnPVnPKeDrsZu-3hLSV1_kQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/WN5APnPVnPKeDrsZu-3hLSV1_kQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/141287" target="_blank" >Using Left, Right, Mid and Len in Visual Basic</a></span>');
document.write('<div>This article contains examples of how to manipulate text strings using the Left, Right, Mid, and Len functions in Microsoft Visual Basic for Applications in Microsoft Excel.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/0QsN5cow-of_aO7Uem0YVUwSrCg\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/0QsN5cow-of_aO7Uem0YVUwSrCg\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/0QsN5cow-of_aO7Uem0YVUwSrCg\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/0QsN5cow-of_aO7Uem0YVUwSrCg\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/75513" target="_blank" >XL: How to Reverse the Order of Words in a Text String</a></span>');
document.write('<div>This article explains how to reverse the order of words in a comma-separated text string by using the FIND, LEFT, LEN, and RIGHT functions in Excel. Suppose that there are two ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/BwOdjoc8iryOP_IiCl2RdNoS060\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/BwOdjoc8iryOP_IiCl2RdNoS060\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/BwOdjoc8iryOP_IiCl2RdNoS060\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/BwOdjoc8iryOP_IiCl2RdNoS060\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/129423" target="_blank" >SUMIF() Function Fails If Sum_Range Contains Links to Text</a></span>');
document.write('<div>Any cell in the sum_range that contains a link to text causes this problem when a cell ... Excel 5.0 Samples file in your Excel directory in cells C14:E16 on the Worksheet Functions ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/CpWM7zrhdZwNAogSkl8fv9h2DU0\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/CpWM7zrhdZwNAogSkl8fv9h2DU0\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/CpWM7zrhdZwNAogSkl8fv9h2DU0\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/CpWM7zrhdZwNAogSkl8fv9h2DU0\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/828125" target="_blank" >Excel statistical functions: DVAR, DVARP, DSTDEV, and DSTDEVP</a></span>');
document.write('<div>The functions take as observations the field values in each database record that ... from its initial value of 0, these values appear in parentheses in the text ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VwICrbXX3dwCp35elc3AR0H4KdA\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VwICrbXX3dwCp35elc3AR0H4KdA\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/VwICrbXX3dwCp35elc3AR0H4KdA\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/VwICrbXX3dwCp35elc3AR0H4KdA\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/103839" target="_blank" >Regression Analysis and Best Fit Lines (XE0124)</a></span>');
document.write('<div>Text of Xe0124 The following is the full text of the Application Note. (Note that ... The functions give you more power and flexibility than the AutoFill feature does.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/L34BkU_oOyS5t3o4yw2ZaFFdK1E\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/L34BkU_oOyS5t3o4yw2ZaFFdK1E\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/L34BkU_oOyS5t3o4yw2ZaFFdK1E\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/L34BkU_oOyS5t3o4yw2ZaFFdK1E\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/324986" target="_blank" >How to use the LOOKUP function in Excel</a></span>');
document.write('<div>... that contains text, numbers, or logical values that you want to compare with lookup_value. The array form of LOOKUP is similar to the HLOOKUP and VLOOKUP functions.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/RgGyiXZvV2xX1FktvvhOODlPhqI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/RgGyiXZvV2xX1FktvvhOODlPhqI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/RgGyiXZvV2xX1FktvvhOODlPhqI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/RgGyiXZvV2xX1FktvvhOODlPhqI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214153" target="_blank" >How to count the occurrences of a number or text in a range in Excel ...</a></span>');
document.write('<div>This article explains how you can use worksheet functions in Microsoft Excel for Mac to count the number of occurrences of a specific number or text string in a range of cells on a ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2gMVVGhq8aHV1y7zcEPVxiDNsWQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2gMVVGhq8aHV1y7zcEPVxiDNsWQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/2gMVVGhq8aHV1y7zcEPVxiDNsWQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/2gMVVGhq8aHV1y7zcEPVxiDNsWQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213649" target="_blank" >XL2000: Sample Macro Code to Change Case of Text</a></span>');
document.write('<div>Although Microsoft Excel has functions that change the case of text, there are times when you may want to change text case programmatically. This article contains three sample ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/oVE0Mp5rfYzzdjrqTyxzzy1CIPI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/oVE0Mp5rfYzzdjrqTyxzzy1CIPI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/oVE0Mp5rfYzzdjrqTyxzzy1CIPI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/oVE0Mp5rfYzzdjrqTyxzzy1CIPI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687909.aspx" target="_blank" >How to: Call XLL Functions from the Function Wizard or Replace Dialog ...</a></span>');
document.write('<div>Note also that setting window_title_text to NULL has the effect of ignoring window title ... These functions tell the caller whether \/\/ the current worksheet function was called from one ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vo31zD-mby2IKvtG2LJ-3RpSSzM\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vo31zD-mby2IKvtG2LJ-3RpSSzM\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vo31zD-mby2IKvtG2LJ-3RpSSzM\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vo31zD-mby2IKvtG2LJ-3RpSSzM\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/826371" target="_blank" >Excel statistical functions: VARA</a></span>');
document.write('<div>All functions that are used in cells D3:D10 see the data in A1:A8. VARA treats the text string in cell A1 as the value 0, the numeric values in A3:A7 as numeric values ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/o39Vg-yxf3EvfLTi_vKuRusHcxI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/o39Vg-yxf3EvfLTi_vKuRusHcxI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/o39Vg-yxf3EvfLTi_vKuRusHcxI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/o39Vg-yxf3EvfLTi_vKuRusHcxI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/170787" target="_blank" >Description of limitations of custom functions in Excel</a></span>');
document.write('<div>The functions included in Microsoft Excel also cannot change the environment. Functions can perform a calculation that returns either a value or text to the cell that ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/s4wHKGw4bqvRhO8qgCJoZ4LwBq8\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/s4wHKGw4bqvRhO8qgCJoZ4LwBq8\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/s4wHKGw4bqvRhO8qgCJoZ4LwBq8\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/s4wHKGw4bqvRhO8qgCJoZ4LwBq8\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/912719" target="_blank" >Description of the changes to the Analysis ToolPack (ATP) for ...</a></span>');
document.write('<div>All the ATP functions used C methods to covert between text and number values in Excel 2003 and earlier versions of Excel. In Excel 2007, the ATP functions now use Excel\'s routines ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vmrt_6tLNfLRYzFgJOJp4Pxwx9Y\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vmrt_6tLNfLRYzFgJOJp4Pxwx9Y\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vmrt_6tLNfLRYzFgJOJp4Pxwx9Y\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Vmrt_6tLNfLRYzFgJOJp4Pxwx9Y\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/135796" target="_blank" >ODBC 2.0 Drivers Use the MID() Scalar Function</a></span>');
document.write('<div>and then double-click the selected text to go to the \"Scalar Functions\" topic.\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/qA7gkbvZC1-mYu0Cmd9gLAp8_Ec\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/qA7gkbvZC1-mYu0Cmd9gLAp8_Ec\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/qA7gkbvZC1-mYu0Cmd9gLAp8_Ec\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/qA7gkbvZC1-mYu0Cmd9gLAp8_Ec\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/248822" target="_blank" >How to use custom functions with the Spreadsheet component</a></span>');
document.write('<div>Create an HTML Page with a Spreadsheet Component that Uses the Custom Functions in the COM Object. Using Notepad, create a new text file that contains the following:\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/cj588-3XEF_9pXG1o8v2wTekl_w\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/cj588-3XEF_9pXG1o8v2wTekl_w\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/cj588-3XEF_9pXG1o8v2wTekl_w\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/cj588-3XEF_9pXG1o8v2wTekl_w\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/162762" target="_blank" >Functions Are Not Saved in Lotus 1-2-3 Format</a></span>');
document.write('<div>Functions Are Not Saved in Lotus 1-2-3 Format ... Lotus 1-2-3, click the Index tab in Microsoft Excel Help, type the following text\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oa6igrbC-vLyJgIjKG7E4KFRcuE\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oa6igrbC-vLyJgIjKG7E4KFRcuE\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oa6igrbC-vLyJgIjKG7E4KFRcuE\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Oa6igrbC-vLyJgIjKG7E4KFRcuE\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb239403.aspx" target="_blank" >IsText Method\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>However, in the formula ISNUMBER(\"19\"), \"19\" is not converted from a text value, and the ISNUMBER function returns FALSE. The IS functions are useful in formulas for testing the ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1XqyYRcwgyOgICUx34N6yX7nQZI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1XqyYRcwgyOgICUx34N6yX7nQZI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/1XqyYRcwgyOgICUx34N6yX7nQZI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/1XqyYRcwgyOgICUx34N6yX7nQZI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/100825" target="_blank" >#VALUE error when you add text and values in Excel</a></span>');
document.write('<div>In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error. Although some functions correctly evaluate ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/El-hJS3CIN2AJiclMUqMZByXmDY\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/El-hJS3CIN2AJiclMUqMZByXmDY\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/El-hJS3CIN2AJiclMUqMZByXmDY\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/El-hJS3CIN2AJiclMUqMZByXmDY\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/828340" target="_blank" >Excel statistical functions: TINV</a></span>');
document.write('<div>With the text still selected, use one of the following procedures, as appropriate for ... No modifications were made to the following functions that are called by these inverse ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Jnx6EprVO-HojU2OnKLO0Y3L9c4\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Jnx6EprVO-HojU2OnKLO0Y3L9c4\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Jnx6EprVO-HojU2OnKLO0Y3L9c4\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Jnx6EprVO-HojU2OnKLO0Y3L9c4\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213476" target="_blank" >XL: Unexpected Results with Mixed Text and Numbers in Lookup Table</a></span>');
document.write('<div>In Microsoft Excel 97 and later, when you create a lookup table, the lookup functions may return the #N\/A error value, or, if you are using the functions in a Microsoft Visual ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/cPYCJTH109x-YCC9Tbv55-duujg\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/cPYCJTH109x-YCC9Tbv55-duujg\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/cPYCJTH109x-YCC9Tbv55-duujg\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/cPYCJTH109x-YCC9Tbv55-duujg\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/826772" target="_blank" >Excel Statistical Functions: NORMSINV</a></span>');
document.write('<div>Excel Statistical Functions: NORMSINV ... mini-Normal table\" similar to what you might have seen in a statistics text except ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/NP8bmYiHGAyoHqjrsEfJcqdDXqQ\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/NP8bmYiHGAyoHqjrsEfJcqdDXqQ\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/NP8bmYiHGAyoHqjrsEfJcqdDXqQ\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/NP8bmYiHGAyoHqjrsEfJcqdDXqQ\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/192379" target="_blank" >XL98: Basis Argument for Financial Functions</a></span>');
document.write('<div>XL98: Basis Argument for Financial Functions ... than 8.0), click the Index button in Microsoft Excel Help, type the following text\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GTUL7cA3vnM9SkitaPZbgFoMCHw\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GTUL7cA3vnM9SkitaPZbgFoMCHw\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GTUL7cA3vnM9SkitaPZbgFoMCHw\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GTUL7cA3vnM9SkitaPZbgFoMCHw\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/826409" target="_blank" >Description of the STDEVA statistical function in Excel</a></span>');
document.write('<div>All functions that are used in cells D3:D10 refer to the data in A1:A8. STDEVA treats the text string in cell A1 as the value 0, the numeric values in A3:A7 as numeric values, and ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/-JIj-M4sPezpH5Z33KoWldAoNfw\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/-JIj-M4sPezpH5Z33KoWldAoNfw\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/-JIj-M4sPezpH5Z33KoWldAoNfw\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/-JIj-M4sPezpH5Z33KoWldAoNfw\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/112029" target="_blank" >\"Formula Is Not Valid\" Changing Label Text with FORMULA()</a></span>');
document.write('<div>Note that this is only a problem with unattached text labels. This is not a problem ... about FORMULA(), choose the Search button in the Microsoft Excel Macro Functions Help and ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GItqoyYgHgHdLxXejgC-tZONR3k\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GItqoyYgHgHdLxXejgC-tZONR3k\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/GItqoyYgHgHdLxXejgC-tZONR3k\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/GItqoyYgHgHdLxXejgC-tZONR3k\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/120870" target="_blank" >XL: Overview of ODBC Add-in Functions and Arguments</a></span>');
document.write('<div>NOTE: The functions SQLBind, SQLClose, SQLError, SQLExec, SQLGetSchema, SQLOpen ... DriverPrompt) SQL.REQUEST(connection_string,output_ref,driver_prompt,query_text,col ...\n<p><a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Yc1ITkLy0GCG6WxsegcGfhyVIhI\/0\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Yc1ITkLy0GCG6WxsegcGfhyVIhI\/0\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><br\/>\n<a href=\"http:\/\/feedads.g.doubleclick.net\/~a\/Yc1ITkLy0GCG6WxsegcGfhyVIhI\/1\/da\"><img src=\"http:\/\/feedads.g.doubleclick.net\/~a\/Yc1ITkLy0GCG6WxsegcGfhyVIhI\/1\/di\" border=\"0\" ismap=\"true\"><\/img><\/a><\/p></div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/NsYF"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');