Lotus functionĮquivalent function in Microsoft used without a second argument, the CELL worksheet function returns information about the cell containing the NPER worksheet function requires you to supply a periodic payment value instead of a future function is available only in Lotus 1-2-3 Release 3 or function is available only in Lotus 1-2-3 Release 3 or function is available only in Lotus 1-2-3 Release 3 or Excel does not have an equivalent function. However, Microsoft Excel uses different calculation rules than Lotus 1-2-3 when evaluating text in formulas, certain database criteria, and the value of certain logical operators. Many Lotus 1-2-3 functions have Microsoft Excel equivalents. Lotus 1-2-3 functions that have equivalent Microsoft Excel functions If you want to rewrite Lotus 1-2-3 macros for Excel, see Visual Basic Help.
![lotus 123 database lotus 123 database](http://matnewman.com/Webs/personal/matblog.nsf/IBMNotes9NewSearchOptionAddCustom01.png)
Macros Excel 2000 and later versions of Excel do not run Lotus 1-2-3 macros. If you need to parse data in one column across several columns on the worksheet, use the Text to Columns command ( Data menu). When you open a text file in Excel, the Text Import Wizard will assist you in parsing the data into columns. Parsing text from one column to several In Lotus 1-2-3, you use the Parse command to separate text strings in one column across several columns. You can change the navigation keys in Excel to move around the worksheet in the same way as Lotus 1-2-3. For example, if you press the HOME key in Lotus 1-2-3, the cell in the upper-left corner of the worksheet is selected in Excel, the first cell of the current row is selected. Keys for moving around a worksheet The navigation keys you use to move around a worksheet differ between Excel and Lotus 1-2-3. For example, if you want to format a range of cells, select the cells and then click Cells on the Format menu.
![lotus 123 database lotus 123 database](http://www.os2voice.org/VNL/past_issues/VNL0198H/lotus123.gif)
In Excel, you select the cell, range, or object you want to work with and then choose a command to perform an action. Select first, then choose a command In Lotus 1-2-3, you choose a command and then specify a range that the command will affect.