+ Reply to Thread
Results 1 to 1 of 1

Split Text Inconsistent Data and Delimiters

Hybrid View

  1. 09-25-2019, 08:45 PM #1
    kreiner2006
    kreiner2006 is offline
    Registered User
    Join Date
    02-05-2019
    Location
    St. Louis, MO
    MS-Off Ver
    365
    Posts
    13

    Split Text Inconsistent Data and Delimiters

    I am having trouble finding a way to split the text in column B. Individual entries were uploaded into one cell separated by a date. The date is the only thing that I can guarantee will be consistent. The Date starts what should be my next column of data.
    Last edited by Paul; 09-26-2019 at 01:04 AM. Reason: Removed attachment that appeared to contain sensitive data. If you wish to re-upload another attachment, replace all names, company names, e-mail addresses, etc. with sample data that mimics your dat
    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 the string based on delimiters
    By Reddiiiiii in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-05-2017, 07:47 AM
  2. [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
  3. Split data by delimiters but by formula (not Text to Columns)
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2016, 05:44 AM
  4. [SOLVED] Split data in one single cell to multiple cells with Numbers as delimiters
    By Pumba007 in forum Excel General
    Replies: 7
    Last Post: 04-29-2016, 12:25 AM
  5. [SOLVED] Splitting Inconsistent Text and Numbers With No Delimiters
    By clhockey5779 in forum Excel Formulas & Functions
    Replies: 21
    Last Post: 09-03-2014, 05:52 PM
  6. How to split text from text string into separate columns...no delimiters!
    By droberts2014 in forum Excel General
    Replies: 2
    Last Post: 04-09-2014, 11:48 AM
  7. Split text into array using multiple delimiters
    By TKFRMjarvis in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-26-2014, 03:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1