Can you just import it with the dashes and then do an Edit|Replace to remove
those dashes (select the area first!)?

On 03/02/2011 10:42, Robert Cooper wrote:
In Excel 2007 I am regularly importing information about bonds. The
import includes dashes in the CUSIP number. Is there a way to import
into Excel 2007 eliminating the dashes? I will the copy and paste the
information into Bloomberg and Bloomberg does not recognize the
dashes. I know how to eliminate the dashes following the import. I
am trying to eliminate that step as we will be doing this daily.

--
Dave Peterson