View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
penquicw penquicw is offline
external usenet poster
 
Posts: 3
Default Replace one number in a sequence in a group of cells

I have a group of cells that start with 2 (201, 202, 203 etc.) and I need to
replace that with a 3 (301, 302, 303, etc). Is there a way in "find/replace"
to do this.? I don't know "macros" at all and formulas seem more complex
then just changing the first number in a sequence. Anyone know an easy way?