I've seen this before but I can't remember what (if anything) I did to fix it.
We've done an import of data into Excel (not me so I don't know the specifics).
Some of the cells have a weird display. i.e. instead of showing [CustomerName] is shows [CustomerName" ]
(square brackets are to show the cell, they are not part of the content of the cell).
Anyway, when you go into the cell and delete the '" ' (i.e. the double quote and the space) when you press enter the cell then contains [CustomerNam]. When you go to edit that and remove the 'm' you get [CustomerN] (i.e. it's always removing one extra letter from the end). Even when you add them back in it removes them.
i.e. if you delete the cell entirely and enter 'CustomerName' when you press enter you get [CustomerNam].
Very odd behaviour but I can't find anything online.
If you copy / paste the contacts from one of the affected cells into another blank cell ( on another sheet even) does it still not work correctly when you delete the "
Also try and Copy / Paste as Text and see who that does it
Is there any special / custom formatting on the cells affected
_________________
John_Vella wrote:
OK, so all we need to do is find a half African, half Chinese, half Asian, gay, one eyed, wheelchair bound dwarf with tourettes and a lisp, and a st st stutter and we could make the best panel show ever.
Users browsing this forum: No registered users and 9 guests
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum