Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Trending News

Promoted
?
? asked in Computers & InternetSoftware · 7 years ago

Carriage return in a find/replace?

I'm using an excel spreadsheet document, and basically I need to strip the sheet of HTML and replace it.

I have a load of cells with the <p> tag and I want to do a find/replace to find all instances of the <p> tag and replace it with two carriage returns instead.

I already know that to make a new line in an excel cell is ALT+Enter. This is fine, but I want to make the same change for a load of occurrences quickly. Putting ALT+Enter in the replace field won't do anything.

Thanks for any help

2 Answers

Relevance
  • ?
    Lv 5
    7 years ago
    Favorite Answer

    Just

    enter a space then control-j

    This is Control+minus sign+and j. Do not worry if the replace cell shows nothing. If you want two carriage returns, just repeat the same in the replace with cell two times

    try one for one replace, if it replaces with carriage returns, then select Replace all

    Source(s): experience and tested
  • BT_Bot
    Lv 5
    7 years ago

    Try Alt+010

Still have questions? Get your answers by asking now.