View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
westronwynde westronwynde is offline
external usenet poster
 
Posts: 2
Default underscore in functions

Hi, I hope this has not been asked and I just can't find it. I am having
trouble with underscores in Excel functions. A certain program I use
(industry specific so I can't name it here) exports data into Excel. Most of
the time the data comes over as text. However sometimes I get formulas and
formatting such as this (=_393-_394-_395-_396) Needless to say, this formula
is not helpful and I need to find a way to get rid of this formatting without
having to copy and paste values into another worksheet. Essentially the
formula should look like this =SUM(D4-E4-F4-G4)