+ Reply to Thread
Results 1 to 19 of 19

Split Cells data into specific columns

Hybrid View

  1. 06-30-2017, 06:50 PM #1
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Split Cells data into specific columns

    Thanks JeteMc, I have put the formulas but formula is not working.
    Reply With QuoteRegister To Reply
  2. 06-30-2017, 07:09 PM #2
    JeteMc
    JeteMc is offline
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    19,001

    Re: Split Cells data into specific columns

    Modify the formula in column C to read:
    Formula: copy to clipboard 
    =MID(TRIM(A2),FIND(CHAR(7),SUBSTITUTE(TRIM(A2)," ",CHAR(7),E2-1)),FIND(CHAR(7),SUBSTITUTE(TRIM(A2)," ",CHAR(7),E2))-2-FIND(CHAR(7),SUBSTITUTE(TRIM(A2)," ",CHAR(7),E2-1)))

    Modify the formula in column D to read:
    Formula: copy to clipboard 
    =MID(TRIM(A2),FIND(CHAR(7),SUBSTITUTE(TRIM(A2)," ",CHAR(7),E2)),LEN(TRIM(A2))-1-FIND(CHAR(7),SUBSTITUTE(TRIM(A2)," ",CHAR(7),E2)))

    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
    Reply With QuoteRegister To Reply
  3. 06-30-2017, 07:16 PM #3
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Split Cells data into specific columns

    JeteMc, this formula is not working,
    Reply With QuoteRegister To Reply
  4. 06-30-2017, 07:17 PM #4
    AaruJaan
    AaruJaan is offline
    Forum Contributor
    Join Date
    01-23-2016
    Location
    karachi
    MS-Off Ver
    2007
    Posts
    316

    Re: Split Cells data into specific columns

    you can put this formula into my excel file.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Split Column into Multiple Columns Based Off Specific Criteria
    By hellzone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-31-2017, 09:49 PM
  2. [SOLVED] formula for data to be split to specific columns
    By JEAN1972 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-18-2017, 03:50 PM
  3. [SOLVED] Delete Duplicate Data from certain cells in specific columns
    By telcocook in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-18-2017, 07:40 AM
  4. [SOLVED] Excel - Compare data based upon specific criteria split into columns and delimiters
    By Funkadlic01 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-01-2017, 09:36 PM
  5. [SOLVED] Split specific chars in one column to other columns with no delimiter
    By Fjalar in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-21-2013, 12:28 PM
  6. split data into 2 cells, text to columns
    By ericc2728 in forum Excel General
    Replies: 7
    Last Post: 02-26-2009, 03:03 PM
  7. [SOLVED] Text to Columns - Only want to split SPECIFIC NUMBER of times
    By NewKid in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-03-2006, 10:45 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1