split cells

  1. R

    A mix of Merged/Split Cells in a row to reflect a "family" of separate actions relatint to a "parent" cell?

    Hi all - I'm hoping this is something that can be fixedin Excel to be achieved in one single sheet. I'm building a worksheet to hold client account plan summaries with multipleentries of a client, by my involved offices/teams, with text summaries but cruciallyincorporating a list of actions...
  2. T

    Split multiline text to two column retaining the multiline row structure

    Hi, My data looks like this (two rows, one column) apple [fruit] orange [color] grapes [sour] banana [yellow] mango [sweet] I want to convert them into (two rows, two column) as below apple --------- fruit orange ------- color grapes ------- sour banana ------- yellow mango -------- sweet...
  3. C

    Split and create sorted headings from first part of string

    Hi and thank you. Here is the dilemma...I need to Split the last column and create a heading from the first part of the split with the "/" as seperator. Then sort the heading alphabetically. I Have this: <tbody> DATE NAME AGENT ROLE/NOTE 1/21/2015 Actor A wm George/Likes script...
  4. M

    Counting characters t0 40 and then split ...

    Hi all! Is it possible to count characters to for instance 40, then split the cell to a column. I want to split in hole words. please, please help. Morty07
  5. andrewb90

    Freezing/Splitiing Cells

    Hello All, I have been searching for answers to this and have not found anything helpful, so I am not sure if what I want is doable, but I'll see if anybody has some good Ideas. In the range A2:D18 I have some information I would like on the screen at all times. The user part of the...

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