Home 
Search 
Today's Posts 
#1




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(D4E4F4G4) 
#2




underscore in functions
Hi,
I think your export processing is creating names for the cells. If you click on D4 and look at the white box to the left of the formula bar I bet it'll say "_393". The export process renames "D4" as "_393" and then all formulas refer to the new name. The formulas should all still work though. Sam "westronwynde" wrote: 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(D4E4F4G4) 
#3




underscore in functions
Yes, thank you. I realize it (the export) is creating names for the cells. I
need it not to do this or somehow to beable to rename them back to the alphanumeric indication. The formulas (and cell references) it creates interfer with the manipulation of the data. Say I need to enter an alternative calculation and I have 700 rows of information. Unless I specifically type =sum(A1+B1), I will get cell references when I select these cells (=_364+_365). Now, if I wanted to copy this formula down (i.e. next formula being A2+B2, then A3+B3, etc.) this is fine to do once but having mutiple data sources and having to do this even one for eith column is inefficient. The "underscore" formula does not have extended use and will not change because the cell references will not change. The function stays (=_364+_365) and does not become (=_464+_465). "Sam Wilson" wrote: Hi, I think your export processing is creating names for the cells. If you click on D4 and look at the white box to the left of the formula bar I bet it'll say "_393". The export process renames "D4" as "_393" and then all formulas refer to the new name. The formulas should all still work though. Sam "westronwynde" wrote: 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(D4E4F4G4) 
#4




underscore in functions
Ah, I see. YOu can remove all names in a selected range with the following:
Sub DeleteName() Dim strName As String For Each cell In Selection strName = cell.Name ActiveWorkbook.Names(strName).Delete Next cell End Sub But that may well knacker all the existing formulas. "westronwynde" wrote: Yes, thank you. I realize it (the export) is creating names for the cells. I need it not to do this or somehow to beable to rename them back to the alphanumeric indication. The formulas (and cell references) it creates interfer with the manipulation of the data. Say I need to enter an alternative calculation and I have 700 rows of information. Unless I specifically type =sum(A1+B1), I will get cell references when I select these cells (=_364+_365). Now, if I wanted to copy this formula down (i.e. next formula being A2+B2, then A3+B3, etc.) this is fine to do once but having mutiple data sources and having to do this even one for eith column is inefficient. The "underscore" formula does not have extended use and will not change because the cell references will not change. The function stays (=_364+_365) and does not become (=_464+_465). "Sam Wilson" wrote: Hi, I think your export processing is creating names for the cells. If you click on D4 and look at the white box to the left of the formula bar I bet it'll say "_393". The export process renames "D4" as "_393" and then all formulas refer to the new name. The formulas should all still work though. Sam "westronwynde" wrote: 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(D4E4F4G4) 
Reply 
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 