Extracting count data from a character string

[sbartmasser]

I am working too hard manually. Trying to do a string that will give me the character in the middle between two characters.

I need to do a count between / and ///

SA-GLJE//2221196370/93894/// Med -Dental 9-30. The count varies . So on this it should return 5. I am currently using mid but having change it manually every time. =MID(A21,21,5)*0.01 <colgroup><col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <tbody> </tbody> <colgroup><col width="67" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2450;"> <tbody> </tbody>

<colgroup><col width="365" style="width: 274pt; mso-width-source: userset; mso-width-alt: 13348;"> <tbody> </tbody>

 

[XOR LX]

Hi,

Is there always precisely one occurrence of a single, double and triple forward slash within the string?
If so, do they always occur in the order double-single-triple?
Is the number whose length is to be counted always less than 10 digits long?

If the answer to all of the above is yes:

=LEN(-LOOKUP(1,-MID(A1,FIND("/",SUBSTITUTE(A1,"//","ζ"))+2,{1,2,3,4,5,6,7,8,9,10})))

Regards

 

[jtakw]

Hi,

If your strings are always in the format of your Single sample, this will also work:

Book1
	A	B
1	SA-GLJE//2221196370/93894/// Med -Dental 9-30.	5
Sheet313

Cell Formulas
Range	Formula
B1	=FIND("///",A1)-FIND("/",SUBSTITUTE(A1,"//","||"))-1