Deleting Charactors from a cell and the whole column
 

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.
--
LSC

Deleting Charactors from a cell and the whole column
 

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

--
Gary''s Student - gsnu200775


"Card1234" wrote:

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.
--
LSC