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

Some videos you may like

This Week's Hot Topics