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...
I am trying to separate text text from a single column and put it into multiple columns.
Here is what I have:
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...