Hi,

That did not seem to work, unfortunately. Do you think I am having a
problem because I have both numeric and alphanumeric text? I want the
numeric cells to be treated as text, and in order to do that I need to insert
apostrophes. However, perhaps also inserting the apostrophes in the
alphanumeric cells is causing them to be read with the apostrophe, and
therefore the entire column is not being read.


"Max" wrote:

Try this .. Enter the number: 1 into a blank cell, then copy that cell. Then
right-click on the col Paste special Check "Multiply" OK. That should
help remove the leading apostrophes.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"uncreative" wrote in message
...
Hi, secondary question to this problem. I am able to concatenate & insert
leading apostrophes into a column containing numeric & alphanumeric data.
However, when I try to link tables in Access, no matches are returned
because
I believe that column is being read as 'ABC123 instead of ABC123. If I
click
on each individual cell and hit enter, it works correctly. However, I
have a
thousand cells and am not really interested in doing anything
individually.
Is there another step I am missing? How can I make the apostrophes be read
merely as leading apostrophes?

Thanks,
Tamsyn Hartlen

Not sure, but perhaps try this ..

Assuming source in A1 down

Put in B1:
=IF(A1="","",
IF(ISNUMBER(A1),TEXT(A1,"@"),A1))

Copy B1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"uncreative" wrote in message
...
Hi,

That did not seem to work, unfortunately. Do you think I am having a
problem because I have both numeric and alphanumeric text? I want the
numeric cells to be treated as text, and in order to do that I need to
insert
apostrophes. However, perhaps also inserting the apostrophes in the
alphanumeric cells is causing them to be read with the apostrophe, and
therefore the entire column is not being read.

Ahhh, so simple. That DID work this time, thanks for all your help!

"Max" wrote:

Not sure, but perhaps try this ..

Assuming source in A1 down

Put in B1:
=IF(A1="","",
IF(ISNUMBER(A1),TEXT(A1,"@"),A1))

Copy B1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"uncreative" wrote in message
...
Hi,

That did not seem to work, unfortunately. Do you think I am having a
problem because I have both numeric and alphanumeric text? I want the
numeric cells to be treated as text, and in order to do that I need to
insert
apostrophes. However, perhaps also inserting the apostrophes in the
alphanumeric cells is causing them to be read with the apostrophe, and
therefore the entire column is not being read.

Glad to hear that !
Thanks for the feedback ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"uncreative" wrote in message
...
Ahhh, so simple. That DID work this time, thanks for all your help!