+ Reply to Thread
Results 1 to 2 of 2

Splittng data

  1. #1
    Forum Contributor
    Join Date
    01-03-2013
    Location
    Newport, England
    MS-Off Ver
    Excel 2013 Windows
    Posts
    144

    Splittng data

    I have attached a worksheet example to demonstrate my problem.

    EXCEL HELP.xlsx

    COLUMN A contains data copied in of which some will be joined numbers, like in A1, some blanks (A2), some simple numbers (A3).

    Sean Thomas has been an awesome help in showing me how to join and split the numbers up (B1 & C1).

    But the problem I'm having is working out a suitable IF argument for B2:C3 so that when number imported is joined like A1, it splits them to B and C, if it's blank like A2 then B & C remain blank, or if its simple like A3 then copies to B3, but leaves C3 blank.

    Hope this makes sense!!

    TIA!

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Splittng data

    In B1 enter =IF(LEN(TRIM(A1))=0,"",IF(IFERROR(SEARCH(",",A1),FALSE),LEFT(A1,LEN(A1)-FIND(",",A1)),A1)) and drag it down
    in C1 enter =IF(LEN(TRIM(A1))=0,"",IF(IFERROR(SEARCH(",",A1),FALSE),RIGHT(A1,LEN(A1)-FIND(",",A1)),"")) and drag it down

+ 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