Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
deleting entire rows with the same cell value in the first column | Excel Discussion (Misc queries) | |||
how prevent formula in cell from deleting when deleting value???? | New Users to Excel | |||
Max charactors for 'ActiveWorkbook.SaveAs Filename'? | Excel Worksheet Functions | |||
VBA 'deleting row if a cell in column A is a zero. | Excel Worksheet Functions |