seperate cell

  1. F

    Contact details spreadsheet...!?!

    Hi All, I have inherited a sizeable spreadsheet from a predecessor and need to clean it up to enable me to convert it to a CSV file our our CRM system. The problem is, she has entered all of the telephone numbers into one column and i need to distinguish between landlines and mobiles. Is there...
  2. R

    split contents of cell into other cells

    in cell B1 I have <tbody> 'Stoke 0-1 Aston Villa' how do I get this contents into 5 different cells. F1 'Stoke', G1 '0', H1 '-', I1 '1', J1 'Aston Villa' </tbody><colgroup><col></colgroup>
  3. T

    Running totals using an array of odd cells

    Hi Guys, I am having difficulty being able to set up a simmple formula to create a 'running total' cell, which adds up an array of seperate cells & more importantly when I change to figures/numbers in the sperate cells, they keep on adding up in the running total? I am using cells: N4 N7 N10...

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