split contents

  1. M

    1004 Array too long

    Hi, I am hoping someone will be able to help me break these four arrays in bit sizes pieces so my macro will run. The code is below (in R1C1 and nonR1C1 language). The arrays are using whatever sheet name I am on to search another sheet (Vacation Time) for an employees amount of vacation...
  2. P

    Split $tring into Parts and Paste output into multiple Column/Cells

    Hi group, I have a column within a spreadsheet that contains email addresses. Each row can have one (1) email address or it can have multiple email addresses (occasionally as many as 5 or 6 email addresses). As an example, the spreadsheet could look like this: <tbody> A B C D E F G...
  3. S

    put ^ between number and text EG- 125663232 5555 ^ good day

    hi i need a formula to put ^ in between no and text put ^ between number and text 125663232 5555 ^ good day 456845563 ^ WE ARE HAPPRY 7896846511 ^ HELP YOU
  4. L

    Large List into Average Groups

    Hello, I have a very large list that I need to split equally between, 5 people based on average. This list is by month and alphabet, and I need to take the total counts and split them between 5 people so they would each have around the same alphabet count. In the end, I would have one person...
  5. D

    Splitting Text to Columns at change in case of text

    Hi I am looking for some help on splitting name text into columns and rows. I have text in a cell that looks like <TABLE style="WIDTH: 180pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=240><COLGROUP><COL style="WIDTH: 180pt; mso-width-source: userset...
  6. T

    Split cell into two cells

    I tried looking in the forum and could not find anything that may assist me. I have a cell (C) which may contain: <TABLE style="WIDTH: 329pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=439 border=0 x:str><COLGROUP><COL style="WIDTH: 329pt; mso-width-source: userset...

This Week's Hot Topics

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
Top