Ask Your Question

how to find and eliminate the char '

asked 2015-04-17 07:26:58 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

When I do bank account accounting, I download to excel spreadsheet and import. The ' symbol appears in front of a lot of figures. Sometimes it causes the figure to not be treated like a number and other times it has no effect. I can't see a pattern. I would like to be able to find and eliminate it but I can't figure out how to "find" it with find and replace or even find. The "help" is no help. This symbol does not normal show in the spreadsheet but when you select the cell it does. Trying to format the cell to a number doesn't help either. I have lost hours and hours because of this unfortunate piece of work. This was not a problem before. I think before is before I changed from Excel to Libre Office but I'm not sure. I don't want to change back to Excel. I strongly dislike Microsoft and very much like Open Source and Libre Office, but the time lost is too great. Please help me. There should be a way of put punctuation in quotes or similar. There should be a way to find by ascii char specification.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2015-04-17 09:39:46 +0200

m.a.riosv gravatar image

Menu/Edit/Find & Replace [Ctrl+H]
Enable 'Regular expressions' option.

image description

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2015-04-17 07:26:58 +0200

Seen: 74 times

Last updated: Apr 17 '15