seperate columns

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

    variable "left" formula?

    I am trying to separate text text from a single column and put it into multiple columns. Here is what I have: Column A Tools|Painting & Supplies|Wall Borders & Appliques Tools|Painting & Supplies|Weather Stripping Tools|Personalized Tool Sets|Chestsand here is what I would like it to be...

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