View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Terry Willard Terry Willard is offline
external usenet poster
 
Posts: 1
Default Find and Replace only the first character

I am trying to replace only the first number in a date.
example: 6/6/10 with 7/6/10
I am doing a find 6/ and a replace 7/ but it changes the 7/6 to 7/7 and I
only want to look at the first number in the date. Can anyone help me????