Stripping Out Tab characters from Access Export

[sarchambault]

I've spent TOO long on this. I've got an excel file - created from an
Access database. The key to this problem is that we do NOT want tor
recreate the file - we've already put too much work into it.

In front of every data field is the apostrophe character (or what looks
like the apostrophe character). I want to apply a global function to
strip these stupid characters out. I believe they represent tab
characters.

If I use the Clean function, it does strip out that field, but then I
don't truly have the data... do I? I tried to copy those 'cleaned'
fields and instead of getting the data values, I get the formulas...

I've got to send this file to a printer... It appears that in the IBM
world, you can simply use the edit/replace function and use the alt key
and numeric key pad to define the character... I cannot find/attack
this on the MAC... HELP

thanks a lot
sally

 

[Rob]

I've spent TOO long on this. I've got an excel file - created from an
Access database. The key to this problem is that we do NOT want tor
recreate the file - we've already put too much work into it.

In front of every data field is the apostrophe character (or what looks
like the apostrophe character). I want to apply a global function to
strip these stupid characters out. I believe they represent tab
characters.

If I use the Clean function, it does strip out that field, but then I
don't truly have the data... do I? I tried to copy those 'cleaned'
fields and instead of getting the data values, I get the formulas...

I've got to send this file to a printer... It appears that in the IBM
world, you can simply use the edit/replace function and use the alt key
and numeric key pad to define the character... I cannot find/attack
this on the MAC... HELP

thanks a lot
sally

I am not sure I get the question right but this what I would do: use
=Value( ... )

Enter '23 (apostrophe-2-3) in Cell A1, 23 is entered as text (aligned
left) - apostrophe does not show in cell.

In B1 enter =Value(A1) and you should get a numeric 23. The data in B1
can be used for calculation.

Hope this helps - Robert