Enter line break in excel

  • Hi there,


    I have product description with <BR> tag. I would like to replace with them new line break in excel. But unable to do it. If any suggest me for this so it will be great for me. I am doing manually yet.
    Example:
    description with <BR>


    Item Specifications: <br> Metal Type: Sterling Silver. <br> Metal Stamp or Hallmark: 925. <br> Metal Purity: 92.5% Sterling. <BR> Gemstone Creation Method: Simulated. <BR>Face Measurements From South To North: 7mm. <BR><br><br>Change the color of the metal to rose, yellow, black at additional charge. <br><br>Don't know your ring size?. <br>Here you can find a link to a conversion table of all ring sizes of all country's: (copy & paste into your browser). http://pics.bluenile.com/asset…_sizing_guide_0610-CA.pdf



    After new line insert result


    Item Specifications:
    Metal Type: Sterling Silver.
    Metal Stamp or Hallmark: 925.
    Metal Purity: 92.5% Sterling.
    Gemstone Creation Method: Simulated.
    Face Measurements From South To North: 7mm.



    Change the color of the metal to rose, yellow, black at additional charge.


    Don't know your ring size?.
    Here you can find a link to a conversion table of all ring sizes of all country's: (copy & paste into your browser). http://pics.bluenile.com/asset…_sizing_guide_0610-CA.pdf



    REgards

  • Re: Enter line break in excel


    You should be able to use Find and Replace for this:


    1. In the find field, type <br>. Make sure that the search is set not to be case-sensitive.
    2. In the replace box, enter Ctrl+J. It will look empty, but you will see a tiny dot.


    Now run the search.


    EDIT: Just tested it using your sample data and indeed it does do the job. :)

    Ali :)


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on the like icon bottom right.

    :!:Forum Rules