Ask Your Question

I cannot remove the ' character from a column of cells [closed]

asked 2017-11-20 18:43:47 +0200

Kaelkitty gravatar image

updated 2020-08-09 11:08:05 +0200

Alex Kemp gravatar image

I cant get this column to sum. It is supposed to be currency formatted but when I have been messing about I have discovered that the data in the column all start with a hidden ' ie. '$2.00 I have tried various format commands from the menu, as well as some of the options that popup when right clicking in the cell, nothing seems to work! I f I manually show the contents of one cell in the edit bar and remove the ' by hand the calculation works, but it seems there should be a better solution than doing that 193 times!

Ciao, KK.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Kaelkitty
close date 2019-06-18 10:41:05.879960

1 Answer

Sort by » oldest newest most voted

answered 2017-11-20 18:52:01 +0200

pierre-yves samyn gravatar image


Select the range then DataText to ColumnsOk

Warn: do not use this technique if some cells contain a formula, it will be removed


edit flag offensive delete link more

Question Tools

1 follower


Asked: 2017-11-20 18:43:47 +0200

Seen: 3,446 times

Last updated: Nov 20 '17