escape character

  1. J

    Formula Escape Character

    Hello, I am trying to have a formula which takes an average of a column of B from a range that is controlled by another cell. For example: =AVERAGE(B(N7):B(N8)) where if N7 has a value of 100 and N8 has a value of 200 the outcome would be: =AVERAGE(B100:B200) Thank you in advance
  2. V

    Escape Special Character in Column Name

    Hi all, need some syntax help here. I have these 3 lines of M code shown below (they're part of a larger query): #"Remove % from Load Factor Name" = Table.RenameColumns(#"Merge Periods with Comma",{{"Load Factor%", "Load Factor"}}), #"Divide Load Factor by 100" = Table.ReplaceValue(#"Remove %...
  3. J

    Expression builder escape character?

    I'm trying to set up a default value for a text box. It will be a file path that contains an ampersand. Everytime the form is loaded the text box evaluates the ampersand and so it disappears. C:\J&B changes to C:\JB and so the subsequent code doesn't run. Is there a way to escape the...
  4. J

    How Do I Find Double Quote in Excel

    Can someone please let me know if there is any escape characters in Excel. I'm trying to do something like this: =FIND(""",A1) Thankyou.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top