Apostrophe problem

B

bcap

Hello,

I am working with a spreadhseet and the data looks normal, however
when you click on the cell the data value contains a leading
apostrophe.

for example the data looks like this:

'4
'8
'10
'8


IS there a quick and easy way to get rid of the leading " ' "? If
so, an advice on how to do this would be greatly appreciated!
 
H

Harlan Grove

bcap said:
for example the data looks like this:

'4
'8
'10
'8


IS there a quick and easy way to get rid of the leading " ' "? If
so, an advice on how to do this would be greatly appreciated!
Click to expand...

Select this range of cells, run the menu command Data > Text to Columns,
choose Fixed width in Step 1 of the Convert Text to Column Wizard, and click
on the Finish button.
 
Top