View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
CLR CLR is offline
external usenet poster
 
Posts: 1,998
Default Text file copied

Try the Edit Replace feature, replacing the apostrophe with NOTHING, (just
leave that window blank)........

Vaya con Dios,
Chuck, CABGx3



"Pammy" wrote:

We have copied a text file from our mainframe and it has an ' in front of
each name, I tried going to data - convert text to columns and delimited but
it is still there. Any idea?