Remove '

[marcus]

How do I remove the character ' from a cell? And not just one cell, I
have several hundreds row which have these character. Find & replace
doesn't work.

/Marcus

 

[Beege]

Marcus,

The ' at the beginning that tells Excel that the cell has text and not
numbers?
Insert a column
select / copy offending column
paste special / values
' should be gone...
Delete offending column

Beege

 

[Pete_UK]

Another way not involving an extra column is to highlight the offending
column then Data | Text-to-columns then click Finish. If you have more
than one offending column, you must do each column separately.

Hope this helps.

Pete

 

[Gord Dibben]

marcus

A wild guess...........

The ' could be caused by Transitions settings.

Tools>Options>Transition. Uncheck any Transition settings, especially
Transition Navigation Keys.


Gord Dibben MS Excel MVP

 

[Saruman]

The apostrophe has been added either by someone or when the data was
exported from another application and in Excel, it means the cell contents
is text. This will also include when a number is in the cell.

1. To remove it, in a blank cell type the number 0.
2. Now copy the cell with 0 in it.
3. Highlight the cells containing the apostrophe and Right Click on the
highlighted area
4. Now Paste Special.
5. Under the Operation part of the Paste Special Menu, select the "Add"
radio button and click OK.
6. The apostrophe has now gone.

Be warned, you may get some unexpected results when you do this especially
with numbers, so try it first on a copy.

Hope this helps.