ExcelBanter - interogating a string within a macro

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - interogating a string within a macro - bjy (https://www.excelbanter.com/excel-programming/386248-interogating-string-within-macro-bjy.html)

Brian Young

interogating a string within a macro - bjy

how can i find teh position of 2 charactors within a string ?

ie. string

ahdhhctjdjjd

i need to locate the 'ct' pairing

any suggestions would be appreciated

Stefi

interogating a string within a macro - bjy

x = InStr(1, "ahdhhctjdjjd", "ct")

Regards,
Stefi

€žBrian Young€ ezt Ã*rta:

how can i find teh position of 2 charactors within a string ?

ie. string

ahdhhctjdjjd

i need to locate the 'ct' pairing

any suggestions would be appreciated

All times are GMT +1. The time now is 12:20 AM.