View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vertblancrouge vertblancrouge is offline
external usenet poster
 
Posts: 7
Default Second last character incrematation

Hi

I am planning tag addresses for a software application and my tags look
something like this:

BMS_data.drwr_v[xx]

The problem is when I drag the cells down, Excel 2003 do no increment the xx
because it is not the last character. any way to do that?

I can still delete the ] so the xx can increment but then I still need to
manually add that last character again and eventhough I can use the ? as wild
card to "find" I can't use it to "replace".

Doing find "[?" and replace "[?]" returns "[?]xx"

Thanks for your help.