Forum Discussion
Converting special characters
I am having trouble with data in in a csv file that I created by exporting data from a Filemaker database. The Address field in the database is on multiple lines, but when I look at it in Excel, Ther...
Hi
You may try to copy this little rectangle and create a helper column in which you use a Substitute function
=SUBSTITUTE(D4,"Paste the rectangle",Char(10))
Char(10) pushes what comes next to a new line in the same cell.
You can then copy and paste values from the helper column to wherever you like.
Hope that helps
Nabil Mourad