I have data in a table that allows for hard returns but represents them with a "`" sign. I can't seem to do a replace so that every "`" is turned into a hard return.
My data looks something like this
Patent Application No: 09/342,233`Light Creating Diode`Inventor name: Joe Smith' Application Date : January 2003` Reference No. : 205802
I want to display the same data but with a hard return wehre there is a "`"
I used the formula and only the first line of data displayed.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.