Main Page/IT/LibreOffice

From Lewis Consultancy Wiki
< Main Page‎ | IT
Revision as of 15:26, 9 February 2016 by Clewis (talk | contribs) (Created page with "=Remove Text Formatting Quote= Sometimes Libreoffice does bad things when you import CSV files. You can remove a single quote ' at the beginning of text formatted cells using ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

Remove Text Formatting Quote

Sometimes Libreoffice does bad things when you import CSV files. You can remove a single quote ' at the beginning of text formatted cells using find and replace:

  • select use regex option in find and replace
  • Find for 
     ^.*$
  • replace with 
    &
Retrieved from "https://www.lcnw.co.uk/wiki/index.php?title=Main_Page/IT/LibreOffice&oldid=44"