Thread
:
Remove Leading Comma
View Single Post
#
10
Posted to microsoft.public.excel.programming
GS
external usenet poster
Posts: 364
Remove Leading Comma
Hi Katie,
Try this:
For Each Cell in Range("I3:I10")
If Left$(Cell.Value) = "," Then Cell.Value = Mid$(Cell.Value, 2)
Next Cell
HTH
Regards,
Garry
Reply With Quote
GS
View Public Profile
Find all posts by GS