Formatting a excel sheet that has been created using DTS.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting an excel sheet created by a dts package 1
Hyperlinks changed by Excel again! 5
Link Excel Comment to Sheet, Cell (Bookmark) 1
ongoing hyperlink problem 3
Hyperlink Help 4
How do I make a hyperlink cell-specific between two XL sheets? 3
Excel 03 VLOOKUP hyperlink referencing and formatting 3
make hyperlinks follow the copied sheet, not the original 3

Back
Top