How can I delete the apostrophe in the cell

  • Thread starter msnews.microsoft.com
  • Start date
M

msnews.microsoft.com

I received the data in Excel that in som cells they put ' (apostrophe) in
front of text or number. How can I remove this apostrophe.

Mass removing though. Seems that the find/replacing doesn't work.


Thanks,
 
P

Per Jessen

Hi

Enter 1 in an unused cell, and copy it. Select cells with your data goto
Edit > PasteSpecial > Select "Multiply" > Ok

Hopes this helps.
 
B

Bill Kuunders

One way..........

Type 1 in a blank cell , copy it,

Select the whole range,

Edit->Paste Special->check Multiply->OK.

You will get 0's in any blank cells.
You could do a find and replace on them afterwards.
 
L

lakmerocks

I received the data in Excel that in som cells they put ' (apostrophe) in front of text or number. How can I remove this apostrophe.Mass removing though. Seems that the find/replacing doesn't work.Thanks,
Click to expand...

excellen! enter 1 paste special -multiply - it worked! Gr8! thnx
 

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

Excel does not accept text format! 0
Excel 2010 and the Apostrophe? 1
Can't seem to delete all images from a Word Doc 2
I'm trying to remove duplicate phrasing and words using VBA in Word 2
How do I remove the apostrophe(') in front of zeros 3
How can I remove hidden apostrophe in Excel? 17
Adding an apostrophe to a column of numbers 5
Word macro that can call cells out of Excel for a find and replace 0

Top