+ Reply to Thread
Results 1 to 3 of 3

Parse one cell into 2 or 3 cells

  1. #1
    Forum Contributor
    Join Date
    01-25-2010
    Location
    Virginia
    MS-Off Ver
    Excel 2013
    Posts
    104

    Parse one cell into 2 or 3 cells

    Attached is a sample file. How can I best parse this data?

    The data looks as shown in column A. I need to find a way to fill in the Number, Code, and Priority cells as shown in columns B, C, and D. Sometimes a Priority value exists, and sometimes it does not in the column A data.

    In this sample file I filled in the Number, Code and Priority values to look as I would like them to look after the data has been automatically parsed.

    I will have many files like this with many rows of data like this.

    Can someone help me with this?
    Attached Files Attached Files
    Last edited by SueWithQuestion; 10-01-2010 at 10:53 AM.

  2. #2
    Forum Expert MickG's Avatar
    Join Date
    11-23-2007
    Location
    Banbury,Oxfordshire
    Posts
    2,650

    Re: Parse one cell into 2 or 3 cells

    H, Merged cells are a bit of a problem, but try the attached.
    Regards Mick
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    01-25-2010
    Location
    Virginia
    MS-Off Ver
    Excel 2013
    Posts
    104

    Re: Parse one cell into 2 or 3 cells

    Thank you VERY much. I haven't been able to get back on to the system where I am working on this, but I'm sure once I do that your macro will save the day! Thank you.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1