Remove ' from the beging of the string
 

I have spreadsheet created by importing data from Primavera. In each cell
there is characted which looks like ' but it is not '. Search is not finding
it. It is not shown in the cell, just in the formula bar. How I can remove it
from all cells ???

Regards,

Tony

Remove ' from the beging of the string
 

What I need to do is to remove this formatting character which comes with
importing. If I will copy data, paste to Word as text only and bring it back
cleaning is done. But how to do it directly in Excel ???

Regards,

Tony

"Tony" wrote:

I have spreadsheet created by importing data from Primavera. In each cell
there is characted which looks like ' but it is not '. Search is not finding
it. It is not shown in the cell, just in the formula bar. How I can remove it
from all cells ???

Regards,

Tony

Remove ' from the beging of the string
 

You could put a value of 1 in an unused cell, copy this value, select the
range you want to convert and then Past Special (Paste:All,
Operation:Multiply, Skip blanks). This will remove all leading apostrophes.

Cheers,

Joerg Mochikun


"Tony" wrote in message
...
What I need to do is to remove this formatting character which comes with
importing. If I will copy data, paste to Word as text only and bring it
back
cleaning is done. But how to do it directly in Excel ???

Regards,

Tony

"Tony" wrote:

I have spreadsheet created by importing data from Primavera. In each cell
there is characted which looks like ' but it is not '. Search is not
finding
it. It is not shown in the cell, just in the formula bar. How I can
remove it
from all cells ???

Regards,

Tony

Remove ' from the beging of the string
 

Perfect. Thank you.

Tony

"Joerg" wrote:

You could put a value of 1 in an unused cell, copy this value, select the
range you want to convert and then Past Special (Paste:All,
Operation:Multiply, Skip blanks). This will remove all leading apostrophes.

Cheers,

Joerg Mochikun


"Tony" wrote in message
...
What I need to do is to remove this formatting character which comes with
importing. If I will copy data, paste to Word as text only and bring it
back
cleaning is done. But how to do it directly in Excel ???

Regards,

Tony

"Tony" wrote:

I have spreadsheet created by importing data from Primavera. In each cell
there is characted which looks like ' but it is not '. Search is not
finding
it. It is not shown in the cell, just in the formula bar. How I can
remove it
from all cells ???

Regards,

Tony