Formatting a excel sheet that has been created using DTS.
 

Does anyone know how to remove the leading ' that is added to the start of
every cell by the DTS process. The reason I am trying to do this is to make:

'=HYPERLINK("http://www.microsoft.com", "Click for report")

Loose the leading ', if I do this manually I get the desired hyperlink. How
can I automate this. I have tried left and min, both strip the ' but do not
then result in a hyperlink.

Try selecting your range (single column at a time) and then
data|text to columns.

Choose delimited, but uncheck all the delimiters.

Russell wrote:

Does anyone know how to remove the leading ' that is added to the start of
every cell by the DTS process. The reason I am trying to do this is to make:

'=HYPERLINK("http://www.microsoft.com", "Click for report")

Loose the leading ', if I do this manually I get the desired hyperlink. How
can I automate this. I have tried left and min, both strip the ' but do not
then result in a hyperlink.

--

Dave Peterson