| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 'underscore' line in '__ / __' not printing ??? | Excel Discussion (Misc queries) | |||
| How can I double underscore in excel? | Excel Worksheet Functions | |||
| Splitting 1 cell into 2 based on underscore in text | Excel Worksheet Functions | |||
| how can i make a measurment with and underscore under the second | Excel Discussion (Misc queries) | |||
| underscore between name in excel csv format to export names into o | Excel Worksheet Functions | |||
Threaded Mode
