+ Reply to Thread
Results 1 to 3 of 3

New Column From Carriage Returns In .CSV File

  1. #1
    Registered User
    Join Date
    12-31-2010
    Location
    Kathleen, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    27

    New Column From Carriage Returns In .CSV File

    I have received some great help in the past on this site, I'm hoping someone can come through for me again..

    Have to sort through a .csv file that is downloaded daily, and manipulate the file to make it work for me. Many wasted hours...

    Problem is multiple information is contained in cells, separated by the carriage return symbol. All data is contained in columns A-M. The multi-cell data is in columns J-M.

    Can anybody help me with some code that will put any value after the carriage return symbol into a new column, and keep the values in A-I the same?

    I have attached a copy of the worksheet that shows an example.

    I'm a beginner, and if I knew where to start I'd take a stab at it, but I can't find a relevant example anywhere.

    I really appreciate anyone's help with it.

    Pick Location File.xlsm

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: New Column From Carriage Returns In .CSV File

    Quote Originally Posted by jasono View Post
    Problem is multiple information is contained in cells, separated by the carriage return symbol. All data is contained in columns A-M. The multi-cell data is in columns J-M.

    Can anybody help me with some code that will put any value after the carriage return symbol into a new column, and keep the values in A-I the same?
    But your example workbook says that you want the multi-data cells to be put into new rows, not columns. The following code assumes you mean new rows, as shown in your workbook. Try it on a copy of your workbook.

    Note that the "^" character separating the data in the multi-data cells is exactly that literal character, not a carriage return character (CR, ASCII 13). If this separator really is the CR character in your data, just change the 2 occurrences of "^" in the code to vbCr.

    Please Login or Register  to view this content.
    Post responsibly. Search for excelforum.com

  3. #3
    Registered User
    Join Date
    12-31-2010
    Location
    Kathleen, Georgia
    MS-Off Ver
    Excel 2003
    Posts
    27

    Re: New Column From Carriage Returns In .CSV File

    Works like magic!

    Thanks so much for your help. Marked as solved...

+ 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