Archive of Mr Excel Message Board


Back to Lotus archive index
Back to archive home

What works like Lotus semi colon?

Posted by J Milley on December 07, 2000 12:27 PM
I used the semi colon in Lotus to retain old #'s in cells or to keep notes in certain cells. I know I can use comments in excel to keep notes for cells, but I would like to know if excel has a way to simply separate a new number from an old number within the context of the cell and not have to retype the old number into the comment field. In Lotus all you did was type: 123; 456 this is the old number. Only the 123 showed up but if you looked in the cell, you could see both numbers and the text information.

This *might* work like the Lotus semicolon...

Posted by Tim Francis-Wright on December 07, 2000 9:24 PM

Typing
={123;456}
(including the array brackets) seems
to have the same net effect on Excel as
123;456 has in Lotus. I tried this with a
few functions, and the 456 seemed not to matter.
Hopefully, if I'm wrong, someone will set you
right.


Re: What works like Lotus semi colon?

Posted by bob on December 18, 2000 10:45 AM


Re: What works like Lotus semi colon?

Posted by bob on December 18, 2000 10:46 AM


Re: What works like Lotus semi colon?try the +n("text")

Posted by bob on December 18, 2000 10:47 AM


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.