Deleting Charactors from a cell and the whole column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Card1234 - 26 Mar 2008 00:45 GMT

I have a column of SKU's. The SKU's can be numbers, numbers with dashes,
number and letters, etc. When you view the data in each cell it looks the
way it should (ex. BN12345). When you click on the cell, there is a single
quote (') at the beginning of each SKU. How do I get rid of this? I have
tried formatting as text, Ctrl H (Find and Replace), everything I can think
of. Any suggestions.

Signature

LSC

Reply to this Message

Gary''s Student - 26 Mar 2008 00:50 GMT

Select the cells with the single quotes and run this macro:

Sub tickiller()
For Each r In Selection
With r
.Value = .Value
End With
Next
End Sub

Signature

Gary''s Student - gsnu200775

> I have a column of SKU's. The SKU's can be numbers, numbers with dashes,
> number and letters, etc. When you view the data in each cell it looks the
> way it should (ex. BN12345). When you click on the cell, there is a single
> quote (') at the beginning of each SKU. How do I get rid of this? I have
> tried formatting as text, Ctrl H (Find and Replace), everything I can think
> of. Any suggestions.

Reply to this Message