+ Reply to Thread
Results 1 to 2 of 2

Text to Columns - 30,000 characters

  1. #1
    Registered User
    Join Date
    08-07-2012
    Location
    charlotte, nc
    MS-Off Ver
    Excel 2013
    Posts
    11

    Text to Columns - 30,000 characters

    Hey Guys,

    I have 30,000+ characters in a text file...when I put it in Excel it all goes in to A1, but the consistency here is that there should be a line break at "11000". So every time it sees an "11000" that record should be on a new row. I thought of writing a Macro for it, but is there an easy way to move data from 1 cell to a new row everytime "11000" is seen?

    So you may have 11000 ajsbfkjbsdf 12.23.17 11000 ofinjioanegn 12.11.17 11000 oisenfoiesn 12.10.17

    I would like it to look like this:

    11000 ajsbfkjbsdf 12.23.17
    11000 ofinjioanegn 12.11.17
    11000 oisenfoiesn 12.10.17

    I thought of doing a find and replace, put a comma in front of "11000", then doing a Text to Columns on the comma and removing the comma afterwards....but there are too many characters in 1 cell to do a find and replace.

    EDIT: Actually...I just added the comma in the text file (since it can handle however many replaces you need) and then did Text to Columns in Excel and now it works.
    Last edited by igotgame; 11-14-2017 at 11:15 AM.

  2. #2
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,157

    Re: Text to Columns - 30,000 characters

    Could you prepare such a txt file without "sensitive data", several dozen representative lines in this file ?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Remove Text characters, leaving numerical characters
    By aschwalge in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-01-2016, 06:42 PM
  2. [SOLVED] How to Text to Columns with non unique characters
    By crainaud in forum Excel General
    Replies: 7
    Last Post: 04-30-2015, 09:39 AM
  3. Replies: 3
    Last Post: 03-11-2015, 03:25 PM
  4. text to columns - selecting the last 8 characters of text
    By mmcnellie in forum Excel General
    Replies: 3
    Last Post: 07-26-2013, 03:38 AM
  5. Filtering Multiple Columns Containing Specific Text/Characters
    By abbeycrombie in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-27-2013, 03:40 PM
  6. Replies: 3
    Last Post: 04-05-2012, 04:58 PM
  7. Export multiple columns to single column text files including special characters
    By mike4uuu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2011, 04:54 AM

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