Thread: Manipulating Data in a row
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cesar Zapata Cesar Zapata is offline
external usenet poster
  
Posts: 11
Default Manipulating Data in a row
one way.

Sub takezero()

Dim cell As Range
For Each cell In Range("A1:A100")
cell.Value = Right(cell.Value, Len(cell.Value) - 1)
Next cell



End Sub

Reply With QuoteReply With Quote