The data is pulling from SQL Server with SQL command, I might have multiple columns with numeric values in the database (i.e. calculate 880 minus 61 minus 61, and returning the numeric value 758). Michael wrote: Yes I want Excel to interpret a column as a formula and return a numeric value (i.e. '880-61-61', which is not a number in text form.įrom your description, you might want Excel to interpret that as a formula and calculate 880 minus 61 minus 61, presumably returning the Your SUBSTITUTE formula in AJ4 returns the string I wrote: Instead, in your example, D4 contains the string 'XW-61' and AE4 contains the string '880-61'.