Excel 2003 Cell editing

Topic

New Reply

When partially editing an existing cell, whether in cell or not, the original untouch content is corrupted, e.g. “28 SPARE (OP. INFO)”
is the original contents. I want to replace everything but the number and subsequent space, so I highlight the remainder of the cell and begin typing RIGHT the cell changes as foillows
“2RIGHT)”
shown in the actual cell. In the command line the new data is slightly lower than the old data. and partial characters are shown. When I try to re-insert the character 8 it is put to the left of the 2. Cell format is text and was imported from a MS-DOS text file. font is Arial. Although it is not visible in the cell, when I copy and paste it here there is a leading character – TAB I think.
” 30 SPARE (OP. INFO)”
and from teh ” the format appears to be text although I tried changing to General. HELP!

Reply | Quote

Replies

This is a duplicate entry, I posted an answer in the other one. Could a mighty moderator delete it?

Reply | Quote