Results 1 to 13 of 13

Split cells into the following columns

Threaded View

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Split cells into the following columns

    Hey my friends,

    I need your help to write formula to split/extract data in the given cells.
    In the attached file sheet1, there are five matches in the list. From A to D column.
    In second worksheet, you can see that desired result with the data in these cells is extracted into cells along the columns from F to O.

    Here how it goes:
    A column cell is extracted in terms of first "." in the cell. Left from the point into F, right from "." into G, if there is no "." in the cell like A3, it will be error.
    B column cell is split into H and I in terms of date and hour.
    C column cell, team names will be spllitted into columns J and K in terms of " - "
    D coloun cell is score. The score out of the paranthesis is final score of the match, it will be N and O column. Halftime score is the first score before the comma "," in the paranthesis. If there is no paranthesis in the cell like D2, halftime score colums L and M, it will be error. If there is a score inside paranthesis, but there is no "," like D3, again it will be error.

    Thanks for your interest guys. Waiting for your replys.
    Attached Files Attached Files
    Last edited by aaaaa34; 10-08-2019 at 08:46 AM. Reason: attached file fixed

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split data in cells and copy into specific columns
    By chrisellis250 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 10-11-2019, 06:06 AM
  2. [SOLVED] Need to split one column into two columns based on the number of words per cells
    By terryhenderson in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2018, 03:42 AM
  3. [SOLVED] Split Cells data into specific columns
    By AaruJaan in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 07-01-2017, 08:01 AM
  4. Replies: 8
    Last Post: 04-13-2017, 05:36 AM
  5. Split cells into multiple columns by carriage return
    By taylorcharley in forum Excel General
    Replies: 3
    Last Post: 11-12-2016, 07:59 AM
  6. [SOLVED] Macro attempting to split cells containing multiple co-ordinates into appropriate columns
    By Ethanrholt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2014, 10:56 AM
  7. split data into 2 cells, text to columns
    By ericc2728 in forum Excel General
    Replies: 7
    Last Post: 02-26-2009, 03:03 PM

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