+ Reply to Thread
Results 1 to 4 of 4

merging many lines in one line

  1. #1
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    merging many lines in one line

    hi all
    i have a huge word file every line contain few words ,so what i need is to collect all lines in one line , i don't need any spaces in any line.
    the following are sample :

    IAs big as a football field and nearly as empty,
    Barack Obama's re-election
    headquarters looks like a start-up gone wrong.
    Wires sprout like weeds from the carpeting, legions of
    bookshelves stand empty, and the swing-state maps hastily pinned to
    the wall are freebies from the AAA auto club down the
    street. In one room that could fit hundreds of people, just a few dozen
    sit at long desks. Most don't look old enough to buy a beer
    .so i want them to looks like this ;

    As big as a football field and nearly as empty, Barack Obama's re-election headquarters looks like a start-up gone wrong. Wires sprout like weeds from the carpeting, legions of bookshelves stand empty, and the swing-state maps hastily pinned to the wall are freebies from the AAA auto club down the street. In one room that could fit hundreds of people, just a few dozen sit at long desks. Most don't look old enough to buy a beer.

    kind regards
    Last edited by sherif; 06-01-2011 at 01:24 AM.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,707

    Re: merging many lines in one line

    It depends whether the lines are separated by new lines or new paragraphs.

    If it's new lines, Replace all "^l" with " " ... that's carat l with space, no quotes.

    If it's new paragraphs, Replace all "^p" with " " ... that's carat p with space, no quotes.

    edit: carat is shift and 6

    Regards
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    10-03-2009
    Location
    cairo
    MS-Off Ver
    Excel 2003
    Posts
    33

    Re: merging many lines in one line

    it works perfectly , thanks TMShucks

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,707

    Re: merging many lines in one line

    You're welcome.

    If this has answered your question, please mark your thread as Solved. See my signature for details or the FAQ.

    Regards

+ 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