+ Reply to Thread
Results 1 to 2 of 2

How to paste from webpages into cell and remove line breaks in the process?

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    Neptune
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to paste from webpages into cell and remove line breaks in the process?

    So I want to copy text from webpages into an Excel spreadsheet. I want to do this without the line breaks from the webpage. IE I want it all in one line in the spreadsheet.

    Been trying "paste special" functions and so on to remove formatting, but line breaks stay the same. Any idea on how to do this? I would prefer to do it when pasting, instead of having to apply formulas afterwards, but if formulas is what I need to use, then so be it.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: How to paste from webpages into cell and remove line breaks in the process?

    You can probably use Find & Replace more quickly than applying formulae. Highlight the affected cells, then CTRL-H, then:

    Find What: CTRL-J
    Replace With: <space>
    Click Replace All

    Hope this helps.

    Pete

+ 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. Line breaks in a cell
    By nugentd1 in forum Excel General
    Replies: 1
    Last Post: 09-23-2011, 10:31 AM
  2. Remove Certain Line Breaks in cell
    By hollyc2424 in forum Excel General
    Replies: 1
    Last Post: 05-18-2011, 01:47 PM
  3. Removing Line Breaks In A Cell
    By Ross220681 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-10-2009, 11:14 AM
  4. [SOLVED] Hyperlink in cell with line breaks
    By [email protected] in forum Excel General
    Replies: 4
    Last Post: 07-18-2006, 01:05 PM
  5. Remove Line Breaks ALT + ENTER
    By Highman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-26-2005, 05:06 PM

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