Results 1 to 6 of 6

Thread: splitting string and copy to other cells

  1. #1

    splitting string and copy to other cells



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    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

  3. #3
    Can you provide more details. I don't see a text-to-columns formula or split formula.

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    869
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by bricast View Post
    I don't see a text-to-columns formula or split formula.
    Here is tutorial example.
    If you want formula, see attach
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  5. #5
    Acolyte candybg's Avatar
    Join Date
    Jul 2015
    Posts
    92
    Articles
    0
    Excel Version
    2010 and 2016
    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 by candybg; 2015-07-27 at 10:01 PM.

  6. #6
    Great thanks candybg that worked like a charm.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •