substitution

My pivot tables have lots of 0.00 values. PivotTable Option formatting only allow one substitution: For empty cell values show: -- Is there an option to include another substitution: For 0.00 values cells show: -- See the example below where Spaces, Enrolled, Available are all Dax...

Hello dear Excel users! I got hung up on my lacking knowledge regarding Excel. My aim is to get a CSV input, which has several coloums, but only 2 is of interest: one which determines the type of data and a number value, which is to be copied unchanged. The output would have a completely...

I have the following formula enter in to "A2": =SUBSTITUTE( (SUBSTITUTE( ("$GR$1"), (1), ("") )), ("$"), ("") ) ; is there a way to make both nested substitutions of "1" and "$" with a single substitute function?

I would like to return the date ranges for which products were substituted but I'm having difficulty with the filters. I have a "sub" flag in my Orders table that indicates if a product was substituted (the product ID is different than that in our item master file). I have a calendar table...

Hello. Is there a way to create a multiple substitution so that for a number of specific characters I get different ones? I need this for transposition of notes in music. So for example, for each letter "C" I get a "G", for a "D" an "A" and so on. The thing is that to cover up all the scale, I...

Hi All, I tried my best to fix the issue myself and couldn't figure out for hours and hope I get some help here. Am trying to pass a variable to a range through another subroutine. If argument is of same datatype, it works. But if multiple datatype, then getting "Type mismatch error 13". Am...

Hi, I've been trying to make a macro for making a simple substitution cypher but although I managed to do so in Python I don't know enough to make a macro. The desired outcome would be to type a phrase in, say, cell A1, run the macro and then have the result appear in cell A2. It's not a...

Hello, I'm just trying to build a spreadsheet that will allow me to paste a column of text strings into column C that will parse the text and replace any non-alphanumeric characters with their octal codes (For example turn "(TM)" into "\236"). The symbols to replace will be in column A, the...