Free Microsoft Excel 2013 Quick Reference

Help for Lotus 1-2-3 users in Excel 2003

In older versions of Excel, there used to be a way to get Excel to
"translate" Lotus 1-2-3 commands into Excel keystrokes. Anyone know if this
is still possible? Standard Help doesn't answer this.
--
Djhawk


Post your answer or comment

comments powered by Disqus
In older versions of Excel, there used to be a way to get Excel to
"translate" Lotus 1-2-3 commands into Excel keystrokes. Anyone know if this
is still possible? Standard Help doesn't answer this.
--
Djhawk

In older versions of Excel, there used to be a way to get Excel to
"translate" Lotus 1-2-3 commands into Excel keystrokes. Anyone know if this
is still possible in Excel 2003? Standard Help doesn't answer this.

--
Djhawk

In older versions of Excel, there used to be a way to get Excel to
"translate" Lotus 1-2-3 commands into Excel keystrokes. Anyone know if this
is still possible in Excel 2003? Standard Help doesn't answer this.

--
Djhawk

I was emailed a file saved in Lotus 1-2-3. I have Excel 2003 and get an
error that it can't open Lotus 123 files. Surely if Word can open a
WordPerfect document, Excel can open a Lotus 123 file. What am I missing?

Tips for Importing Lotus 1-2-3 Files to Excel

... assumes the first column is sorted and finds the closest value in the first column that does not exceed the lookup value. The VLOOKUP and HLOOKUP worksheet functions in ...

Tips for Importing Lotus 1-2-3 Files to Excel

... are evaluated differently when you extract data, find data, and use database functions ... 5th = = Logical NOT #not ...

Tips for Importing Lotus 1-2-3 Files to Excel

However, database criteria ranges are evaluated differently when you extract data, find data, and use database functions. For example, a criteria of "John" finds only ...

Hello Everybody,

Purchase new computer with Vista,
Vista nixes installation of my old Lotus 1-2-3 program (registry
upset),
Purchase Excel 2007,
Excel nixes understanding of Lotus 1-2-3 files,
Google-search internet and find media-convert.com, which succeeds in
converting a few Lotus files to Excel but gives up repeatedly on
others,
Google-search again and discover at pcworld.com a free download of
"Excel File Conversion Wizard" (yes, also from Lotus 1-2-3 to Excel)
with not a word of usage instructions,
Download it to where?,
Finally find it on Desktop as fileconv.xla,
Try Excel now,
Just as dumb as before,
Then try clicking on fileconv.xla itself,
Excel again plays dumb BUT also sends a note analyzing why it is dumb:
"Errors were detected in file fileconv.xla" and "This workbook has
lost its VBA project, ActiveX controls and any other programmability-
related features".

Obviously something more than just download should be done, but what?
Curtain, end of the game for this scant brain. Anybody knows? Anybody
wants to restore happiness to the world?

Hugs, Clas

Hi, I imported a Lotus 1-2-3 file (in .wk4 format) into Excel 2003, and then
saved
the file in Excel format. However, the size of the converted file was
really big.

Original Lotus 1-2-3 file size: 500 KB
Converted Excel file: 14MB

It seems that the converted file has a lot of free space in it as the zipped
version
is only about 400 KB.

Please help if you encountered this problem before. Thanks. K Learner

Is there a way to automate importing Lotus 1-2-3 files into Excel? It could be via command line (batch file) or VBA.

Thanks in advance.

Oh yeah, not sure which version of either software. I think Excel is 2000 or 2002.

Is it possible to control Lotus 1-2-3 from within Excel?

can you please help me by telling me how to use lotus commands in the excel
2003 version as their seems to be no simple solution. i have set the
transition check boxes to checked (to no avail) and have looked on the help
and online help sections without success.

many thanks

Way back in the deep dark recesses of my memory I seem to recall some way of
extracting all unique values of a certain field from a database in Lotus
1-2-3 to a different portion of the spreadsheet. I have a need to do the
same thing now, but like most of the world, I am using Excel now. I can't
seem to figure out how to get this done in Excel...in Lotus...I think it was
with a data - extract command.

Thanks for the help !!

XL2000: Tips for Importing Lotus 1-2-3 Files into Microsoft Excel

... Excel assumes the first column is sorted and finds the closest value in the first column that does not exceed the lookup value. The VLOOKUP and HLOOKUP worksheet functions in ...

My first post:

I took a spreadsheet course way back around 1992-3 at a community college, I think it was Lotus 1-2-3. I have various versions of Excel for Windows ranging from about 2000 to 2007 on 3 different PCs, and I figure these programs are probably in oh so many ways very similar to that Lotus version I was running almost 20 years ago.

I haven't been using spreadsheets very much. Of course, once in a while I download an XLS file and open it, resize a few columns, that's about it.

I do databases, Foxpro (Visual FoxPro) routinely and write code, mess with the tables, browse, etc. but I think I should be using Excel for some of this stuff. How can I get some chops in Excel at this point reasonably quickly? Should I do tutorials embedded in the program, online tutorials, check out YouTube, just poke around in help? Should I (do I have to) look at that puppy wagging its tail at me? I usually ditch that dog...

I'd like to have some automatic processing of cells, some sums, averaging, probably some more fancy stuff. Once I get the hang of it, I'll no doubt dream up some great things. I have some of this going on using FoxPro, but I think Excel is probably what I should be using for some of this stuff. I'd appreciate some suggestions on how I can get some real facility using Excel and avoid a lot of frustration in the process. Thanks.

My company has always used Lotus 1-2-3 for spreadsheets in the past. I
am now the financial person and I have vowed to change all my files to
Excel. I have an IF formula that translates to #VALUE, when I am
asking it for ------, as the result to an IF statment in the previous
column that answers a ------ value. Can anyone help me? What info do
I need to post? Or would it be easier if I emailed the file?

Thanks for any help you can give me.

Cheri

In Tools...Options..Transition, I used to be able to select Lotus 1-2-3 Help
and use the forward slash key to bring up cell formatting options. Excel
2003 no longer offers this option. Where else may I find this option or what
else can I do (besides use the MS office Excel menus)?

XL98: Functions Are Not Saved in Lotus 1-2-3 Format

... occurs if your workbook contains any of the following Microsoft Excel worksheet functions: ... IPMT ISBLANK ISERROR ISLOGICAL LINEST LOGEST LOOKUP MATCH ...

XL98: Functions Are Not Saved in Lotus 1-2-3 Format

... occurs if your workbook contains any of the following Microsoft Excel worksheet functions: ... MINVERSE MIRR MMULT PPMT PRODUCT SEARCH SUBSTITUTE TEXT ...

XL2000: Tips for Importing Lotus 1-2-3 Files into Microsoft Excel

... are evaluated differently when you extract data, find data, and use database functions. ... 5th = = Logical NOT #not ...

Functions Are Not Saved in Lotus 1-2-3 Format

... occurs if your workbook contains any of the following Microsoft Excel worksheet functions: ... MMULT PPMT PRODUCT SEARCH SUBSTITUTE TEXT TRANSPOSE TREND TYPE WEEKDAY ...

XL2000: Tips for Importing Lotus 1-2-3 Files into Microsoft Excel

However, database criteria ranges are evaluated differently when you extract data, find data, and use database functions. For example, a criteria of "John" finds only rows with ...

Functions Are Not Saved in Lotus 1-2-3 Format

... occurs if your workbook contains any of the following Microsoft Excel worksheet functions: ... LOOKUP MATCH MDETERM MINVERSE MIRR MMULT PPMT PRODUCT SEARCH SUBSTITUTE TEXT TRANSPOSE

When opening files in Excel 2003, there was an option to open Lotus 1-2-3
files (*.wk?). I have upgraded to Excel 2007 and no longer see that option;
nor can I open Lotus 1-2-3 files. Did Miocrosoft remove this capability from
Excel 2007?


No luck finding an answer? You could always try Google.