erasing

  1. C

    I need a formula to a) find the first numeral in a text string b) remove that numeral and all the characters after that numeral

    Hi, I need help to erase all characters after the first numeral in a text cell, including the first numeral itself. Unfortunately, I only have the Microsoft Ofice Professional Plus 2021 version of Excel. So I don't have functions like TextAfter or RegEx. Examples of the cells I want to edit...
  2. J

    Erasing Arrays after use question

    Hi, I have a macro that uses multiple arrays and after use I have a reset button which clears these: erase MyArray1 etc... However in some cases not all arrays are initiated so when I attempt to erase those I get an error as they don't exist. Is there a way, when erasing them to check if they...
  3. M

    Formula: If condition is false don't change current cell value

    I am trying to create an excel sheet that keeps track of my teams progress throughout the week. I put an example of what I currently have below as well as the formulas. <tbody> Name Complete Total 12/31/18 1/1/19 1/2/19 1/3/19 1/4/19 1/5/19 Mike 9 10 =if(D$1=Today(),$B2/$C2,"")...

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