Counting number of characters between 2 values in string

**ashraf999** · 01-28-2012, 02:34 AM

I am trying to count characters between 2 "-"'s and another between a "-" and " " in a string. For example, the formula on "B-213-01 " should return 3 for the first part and returns 2 for the second.

Regards,

**pike** · 01-28-2012, 03:10 AM

Hi ashraf999
to count between the -'s
=LEN(TRIM(MID(SUBSTITUTE(B3,"-",REPT(" ",100)),100,100)))

**pike** · 01-28-2012, 03:19 AM

ops the second part

=LEN(TRIM(RIGHT(SUBSTITUTE(B3,"-",REPT(" ",100)),100)))

**ashraf999** · 01-28-2012, 03:29 AM

Thanks. Solved !

Originally Posted by pike

Hi ashraf999
to count between the -'s
=LEN(TRIM(MID(SUBSTITUTE(B3,"-",REPT(" ",100)),100,100)))

Thread: Counting number of characters between 2 values in string

Thread Tools

Display

Counting number of characters between 2 values in string

Re: Counting number of characters between 2 values in string

Re: Counting number of characters between 2 values in string

Re: Counting number of characters between 2 values in string

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions