Text in Excel is lost
 

I typed in some text in a cell, saved the workbook and moved on. When I went
back into the document, I found that some of the text had been deleted in a
number of cells. Sentences were cut off in the middle (and there was plenty
of room in the cell so that's not the problem). Is there a setting that
might have changed in the workbook that would have deleted text without me
knowing? This is really weird.

Maybe all the text was still in the cell, but you just couldn't see it.

When you selected the cell, could you see all the text in the formulabar?

If yes, you can add alt-enters every 80-100 characters. Then you can see more
when you're looking at the cell (not the formulabar).

If this doesn't help, you may want to give more info--Version of excel, length
of text in cell (you can use a formula like =len(a1) to get the length. And
even how you saved the workbook (was it really a .xls workbook?)

PGP wrote:

I typed in some text in a cell, saved the workbook and moved on. When I went
back into the document, I found that some of the text had been deleted in a
number of cells. Sentences were cut off in the middle (and there was plenty
of room in the cell so that's not the problem). Is there a setting that
might have changed in the workbook that would have deleted text without me
knowing? This is really weird.

--

Dave Peterson

Thanks Dave - it's Excel 2000 and was saved as a workbook. When I click on
the cell, the formulabar shows what I see in the cell. It's not a matter of
too much text in the cell, rather I'm afraid it's going to turn out to be
unauthorized editing (workbook is on a share file). I just wanted to see if
there were any tricks or tools that might have inadvertently been used and
created this problem. Thanks again! PGP
--
Thanks in advance for all your help. PGP


"Dave Peterson" wrote:

Maybe all the text was still in the cell, but you just couldn't see it.

When you selected the cell, could you see all the text in the formulabar?

If yes, you can add alt-enters every 80-100 characters. Then you can see more
when you're looking at the cell (not the formulabar).

If this doesn't help, you may want to give more info--Version of excel, length
of text in cell (you can use a formula like =len(a1) to get the length. And
even how you saved the workbook (was it really a .xls workbook?)

PGP wrote:

I typed in some text in a cell, saved the workbook and moved on. When I went
back into the document, I found that some of the text had been deleted in a
number of cells. Sentences were cut off in the middle (and there was plenty
of room in the cell so that's not the problem). Is there a setting that
might have changed in the workbook that would have deleted text without me
knowing? This is really weird.

--

Dave Peterson

There could be macros running in the background that change the values in the
cell. But since the workbook is shared, I'd guess human error to begin with.

PGP wrote:

Thanks Dave - it's Excel 2000 and was saved as a workbook. When I click on
the cell, the formulabar shows what I see in the cell. It's not a matter of
too much text in the cell, rather I'm afraid it's going to turn out to be
unauthorized editing (workbook is on a share file). I just wanted to see if
there were any tricks or tools that might have inadvertently been used and
created this problem. Thanks again! PGP
--
Thanks in advance for all your help. PGP

"Dave Peterson" wrote:

Maybe all the text was still in the cell, but you just couldn't see it.

When you selected the cell, could you see all the text in the formulabar?

If yes, you can add alt-enters every 80-100 characters. Then you can see more
when you're looking at the cell (not the formulabar).

If this doesn't help, you may want to give more info--Version of excel, length
of text in cell (you can use a formula like =len(a1) to get the length. And
even how you saved the workbook (was it really a .xls workbook?)

PGP wrote:

I typed in some text in a cell, saved the workbook and moved on. When I went
back into the document, I found that some of the text had been deleted in a
number of cells. Sentences were cut off in the middle (and there was plenty
of room in the cell so that's not the problem). Is there a setting that
might have changed in the workbook that would have deleted text without me
knowing? This is really weird.

--

Dave Peterson


--

Dave Peterson