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.

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

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

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.

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

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



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