+ Reply to Thread
Results 1 to 2 of 2

Make a cell resize and fill contents into a cell when data is on separate lines

  1. #1
    Registered User
    Join Date
    07-20-2009
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    5

    Make a cell resize and fill contents into a cell when data is on separate lines

    I have addresses in a text file, and they're all on different lines (see 1st Image).

    When I copy and paste this data to an excel file, they all appear on different lines, not matter how much I try to get it into a single cell. I have word wrap checked.

    However, if I remove the line breaks in the text file and then do a copy and paste, all the data appears in a single cell. I have to add line breaks in the cell manually.

    There are some 500+ addresses. Do you know how I can do this without having to remove line breaks and add then all over again?

    excelFile.jpg

    textFile.png

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,770

    Re: Make a cell resize and fill contents into a cell when data is on separate lines

    Copy and paste the Text File data in Ms-Word and use Find and Replace (Ctrl+H) and in Find What type ^13 and leave blank in Replace with and press Replace All and Copy and paste the Replaced data to Excel.


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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