split and remove

  1. R

    VBA Help - Split Data Worksheet with helper sheet into separate workbooks, preserve all formatting and structure and PW protect sheet

    Hi All, I have a spreadsheet that I need to split out a each unit and then password protect it. my spreadsheet will contain formatting and protected areas. I need to Retain all functionality in the split out files as well as update a master cell with the budget for that unit. I have some...
    • R19F84R
    • Thread
    • password protect split and remove vba & conditional formatting & protected worksheet
    • Replies: 6
    • Forum: Excel Questions
  2. B

    VBA transferring cells with defined content from a worsheet to another

    Hello everyone, I would like to know how I could transfer cells from a worksheet to another, regarding the content of the cells. For instance, I have a first worksheet with cells that can contain "january" or, "february", or any months, and then I have a different worksheets for each month. I...
    • bbnhn
    • Thread
    • cell (value) selection.texttocolumns split and remove split cell contents textocolumns vba & excel
    • Replies: 0
    • Forum: Excel Questions
  3. P

    Remove Numbers at Beginning of text from a cell

    I have huge text data contains list of topics and course contents.I am facing a challenge to remove intro section numbers and session Numbers and much more to a normal text pattern. Individual removing them is taking a lot of time and effort. I need the help of Mr. Excel Experts in resolving...
  4. C

    I have a column with Date and time in the same field, how to I split or change so I only have the date?

    HI all, I hope someone can help. I have a Dtae&time column with 04-07-2019 15:17:10. I only need the date (preferably as 04.07.2019). I have tried to simply reformat the date to another format but that does not work. Any ideas? Thanks in advance.
  5. M

    UDF - Custom Split and Remove

    Hey there, I've created a custom function which compares two text strings, and removes any duplicates. For instance String 1 = "Bob; Sally; Tom; Beth;" String 2 = "Sally; Beth;" Resulting String = "Bob; Tom;" I have two issues. One is that my function is being recalculated needlessly. For...

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