x404.co.uk
http://www.x404.co.uk/forum/

Excel Issue
http://www.x404.co.uk/forum/viewtopic.php?f=4&t=15781
Page 1 of 1

Author:  Fogmeister [ Fri Feb 03, 2012 10:16 am ]
Post subject:  Excel Issue

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.

Anyone got any ideas?

(BTW it's an XLSX file not CSV or anything).

TVM

Author:  jonlumb [ Fri Feb 03, 2012 11:20 am ]
Post subject:  Re: Excel Issue

For a name in cell A1, could you use something like

=LEFT(A1,Len(A1)-2)

and then play around with the numbers if required?

Also perhaps just see what the Len() function returns on its own as well

Author:  hifidelity2 [ Fri Feb 03, 2012 11:37 am ]
Post subject:  Re: Excel Issue

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

Page 1 of 1 All times are UTC
Powered by phpBB® Forum Software © phpBB Group
https://www.phpbb.com/