Excel truncates text strings of spaces?

M

Me!

Hi,

I have a large table in an Access project (.adp), one field of which is
a 20-character alpha-numeric code, where each character signifies something.

The code may contain internal spaces i.e ABCDEFGHIJ 12345678
where char's 11 and 12 are spaces.

However, when I copy the data into Excel some (not all?) of the internal
spaces are truncated, leaving me with 18 and 19 character codes?

Does anyone know why Excel does this and how I can prevent it.

I'm investigating ways to possibly prevent it on the MS Access side but
would welcome any Excel-specific advice.

Many thanks.
 
G

Gary''s Student

Insert a single quote (apostrophe) before each of the 20 character strings.
 
M

Me!

Doesn'y work I'm afraid. I've tried prefixing the strings with an
apostrophe (within Access) but when it's copied over it still happens?
 
D

Dave Peterson

I don't use Access, but I've never seen excel do this.

Can you copy|paste into NotePad to see if the problem exists when you paste it
there?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying truncates strings of spaces? 8
Advice for field structure or query structure - not getting theresults I thought I should 2
Access 2002 truncates text when linking to Excel 2002 1
How to extract specific text from a string of characters 6
Post Code UK Structure Verification 1
Removing Scientific Notation 8
Excel Solved - Using Excel 2007 Large()/Small() function without duplicate values! 1
Excel Building Excel VBA Dynamic SQL Query- difference between Excel 2007 & 2010 0

Top