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.
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.