Remove ' from the beging of the string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
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
 
Perfect. Thank you.

Tony

Joerg said:
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
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell shows the last typed text, no matter where it is typed 0
Formula appearing as Value in Formula Bar 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
VBA set thick borders around non empty cells in range 0
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Manipulating Strings in a Macro 2
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
formattig word paragraphs from excel 5

Back
Top