splitting string and copy to other cells

B

bricast

New member
Joined
Jul 27, 2015
Messages
3
Reaction score
0
Points
0
How would I take a string that was the category in our old helpdesk system to split it into each category level which could be up to 4? The string looks something like this.
category1\category2\category3\category4. I need a way to slit these into their own cells.
 
I think you could you use Text-to-Columns and split the data at the <\> sign, if the data were organized as your example shows with the <\> sign between data segments.

Hope this helps!
cbug
 
Can you provide more details. I don't see a text-to-columns formula or split formula.
 

Attachments

  • Split TextCell.xlsx
    47.9 KB · Views: 7
Sure. You can find it under DATA - Text To Columns.
- Be sure to insert some blank columns after your data (4 columns if you have 4 parts to the data).
- Copy your data column to the first new column you inserted.
These 2 extra steps will preserve your original data in case you make a mistake : )

Hope this helps!
cbug
 
Last edited:
Great thanks candybg that worked like a charm.
 
You must log in or register to reply here.
Back
Top