Reply to topic  [ 3 posts ] 
Excel Issue 
Author Message
I haven't seen my friends in so long
User avatar

Joined: Thu Apr 23, 2009 7:35 pm
Posts: 6580
Location: Getting there
Reply with quote
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

_________________
Oliver Foggin - iPhone Dev

JJW009 wrote:
The count will go up until they stop counting. That's the way counting works.


Doodle Sub!
Game Of Life

Image Image


Fri Feb 03, 2012 10:16 am
Profile WWW
Spends far too much time on here
User avatar

Joined: Thu Apr 23, 2009 6:44 pm
Posts: 4141
Location: Exeter
Reply with quote
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

_________________
"The woman is a riddle inside a mystery wrapped in an enigma I've had sex with."


Fri Feb 03, 2012 11:20 am
Profile WWW
I haven't seen my friends in so long
User avatar

Joined: Fri Apr 24, 2009 1:03 pm
Posts: 5041
Location: London
Reply with quote
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.


Fri Feb 03, 2012 11:37 am
Profile
Display posts from previous:  Sort by  
Reply to topic   [ 3 posts ] 

Who is online

Users browsing this forum: No registered users and 8 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

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software.