- make a copy of the file (for backup)
- open the file with Libre Office (with Neo Office on Mac)
- click on "Edit" then "Find and replace"
- a window appears
- in the "Search" field, type: \n
- in the field "Replace with", type the character Space
- click on the "More options" button
- tick the box "Regular expressions".
- at the bottom, in "Search in", select "Values"
- at the top, click on "Replace All"
Search
2018/04/06
My import file contains line breaks in the cells
To remove the line breaks inside the cells of your import file:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment
We will usually reply within 04 – 24 hours (but Saturday and Sunday)