no spaces

  1. M

    Using Split Function to add a hyphen to telephone number

    I am trying to use a split function but it keeps saying subscript out of range. The input is 1234567 (any 7 digit number) and the output needs to be 123-4567. so a user can enter their telephone number but it will add the hyphen for them. I can get it split when it has spaces but not without...
  2. J

    Formula for Item Number (consective, ignoring blank lines)

    Hello world! 1st post. I'm trying to generate item numbers for quoted items in my quoting template. It should be simple, but I can't figure out how to skip blank lines (which happen often in our world) and continue counting from the previous number. Example: Item # - Data -...

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