View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Katie Katie is offline
external usenet poster
 
Posts: 130
Default Remove Leading Comma

Hello all- I know that we spoke before about removing a trailing comma, so i
tried to amend that code to remove a leading comma from a range, but it's not
working in cells where there's anything after the comma. Could anyone point
out what I did wrong with this code?

Range("I3:I10").Select
For Each cell In Selection
If Left(cell.Value, 1) = "," Then
cell.Value = Left(cell.Value, Len(cell.Value) - 1)
End If
Next