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...
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>
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 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.