+ Reply to Thread
Results 1 to 3 of 3

Split or Replace Carrige Return Line Feed chars

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    47

    Split or Replace Carrige Return Line Feed chars

    hi im trying to create a macro that with take multi line text
    eg:
    this
    is
    text

    and put it all on the one line by either splitting and joining an array or replaceing all the CrLf so it looks like

    this is text

    any help would be appreciated
    Last edited by Aussiexile; 10-07-2010 at 08:39 PM.

  2. #2
    Forum Guru shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,673

    Re: Split or Replace Carrige Return Line Feed chars

    Use data > text to columns, with line feed as a delimiter?
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Registered User
    Join Date
    09-23-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    47

    Re: Split or Replace Carrige Return Line Feed chars

    Quote Originally Posted by shg View Post
    Use data > text to columns, with line feed as a delimiter?
    i need all the data in the one cell.

    it will be taking a title from a document which may encompas multiple lines and putting it on the one line in a single cell

    EDIT: I solved the issue with this bit of code

    tempTitle = Replace(strIn, Chr$(10), " - ")

    thanx to all those that helped
    Last edited by Aussiexile; 10-07-2010 at 08:38 PM. Reason: 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