how do I get an apostrophe deleted from in front of all entries

G

Guest

in each column there is an apostrophe in front of each entry what is the
best way to get rid of thid and how do I keep it off the worksheet?
 
G

Guest

Enter and run the following macro:

Sub tic_killer()
Set rr = ActiveSheet.UsedRange.SpecialCells(xlCellTypeConstants, xlTextValues)
For Each r In rr
If r.PrefixCharacter = "'" Then
r.Value = r.Value
End If
Next
End Sub
 

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

How do I remove the apostrophe(') in front of zeros 3
Adding an apostrophe to a column of numbers 6
Apostrophe In Data Downloaded 6
Leading Apostrophe 14
Apostrophe in Numbers 5
Number Text Format 2
Cell format 6
Formatting to text - apostrophe does not show 3

Top