Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Second last character incrematation
="BMS_data.drwr_v[" & ROW() & "]"
or ="BMS_data.drwr_v[" & ROW()+13 & "]" to start with something other than 1 -- Gary''s Student - gsnu200825 "vertblancrouge" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Second last character incrematation
="BMS_data.drwr_v[" & ROW() & "]"
or ="BMS_data.drwr_v[" & ROW()+13 & "]" to start with something other than 1 -- Gary''s Student - gsnu200825 "vertblancrouge" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Character Set | New Users to Excel | |||
Character | Excel Worksheet Functions | |||
Excel-Match 1st text character in a string to a known character? | Excel Worksheet Functions | |||
Can I create a special character for the Character Map? | Excel Discussion (Misc queries) | |||
RIGHT of character | Excel Worksheet Functions |