Ask Your Question

I need to display, find, remove tab characters in fields in Calc. [closed]

asked 2014-04-06 21:05:43 +0200

samcat gravatar image

updated 2020-09-16 10:59:38 +0200

Alex Kemp gravatar image

Somehow, some of the text fields in my spreadsheet contain tabs. I need to remove them so that I can import the file into another application. I can't figure out how to use them in a "Find" box. Nor display them so that I can delete them manually.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 18:50:01.479849

1 Answer

Sort by » oldest newest most voted

answered 2014-04-06 22:57:34 +0200

David gravatar image

I don't know about display, either, but it's easy enough to find/replace:

  1. Do CTRL-H to bring up find/replace dialog.
  2. Make sure "Other Options" toggle has revealed the other options.
  3. Check the "Regular expressions" box: [✓]
  4. In "Search for" field, put in: \t (that's the regular expression for tab character).
  5. At this point you can click "Find All", and the cells with tabs will be selected;
  6. and/or put your "Replace with" string in, and hit "Replace All".

Obviously, you might want to work on a copy of your file, or save a back-up first. Screenshot below for what it's worth:

Calc Find & Replace

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-04-06 21:05:43 +0200

Seen: 5,388 times

Last updated: Apr 06 '14