queen

  1. C

    Hiding/Unhiding a row in a Password Protected Spreadsheet

    Hi Everyone, I am trying to find out if it is possible to hide/unhide a row on a password protected spreadsheet when the data changes in a cell? I have a Spreadsheet that contains a lot of formulae. In order to prevent people messing with the formulae either inadvertently or maliciously I have...
  2. C

    #VALUE! Displaying instead of " "

    Good Afternoon All, I wonder if someone could point me in the right direction with a formula that returns #VALUE! when the formula is not True. The formula I have is: =IF(day(B71)=3,"Queen's Platinum Jubilee",""). So when B71 doesn't equal 3, I'd rather display a blank cell rather than the...
  3. merryperson

    removing first word from a string

    I wish to catalogue my albums but when they are in excel they are shown by the track number first 06 Killer Queen 02 Spirit in the sky 96 life on mars Some are even shown as 1-01 sweet Love 2-02 Strut your funky stuff I wish to remove the fist word in the string and report just the song title...

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