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/assets/chrome/…ide_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/assets/chrome/…ide_0610-CA.pdf
REgards