Apostrophe problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bcap - 23 Jul 2007 15:39 GMT

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!

Reply to this Message

Peo Sjoblom - 23 Jul 2007 15:56 GMT

Copy an empty cell, select the values and do edit>paste special and select
add

Signature

Regards,

Peo Sjoblom

> Hello,
>
[quoted text clipped - 11 lines]
> 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!

Reply to this Message

Harlan Grove - 23 Jul 2007 16:12 GMT

"bcap" <rayh@patriots.com> wrote...
...

>for example the data looks like this:
>
[quoted text clipped - 5 lines]
>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!

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.

Reply to this Message