Hello I am trying to use MID function for returning a 4 digit number from a text string but it isnt always 4 digits. How do I avoid the return result to be 9340 (when its actually 934) or 0004 ( just return a 4) and lastly if all 0000 just return a blank cell

Examples:

1. 7000000001003313150000000000010000000000934000000000

2. 7000000001003313150000000000010000000000004000000000

3. 7000000001003313150000000000010000000000000000000000

Results I would like is

1. 934

2. 4

3. Blank cell

​Hello I am trying to use MID function for returning a 4 digit number from a text string but it isnt always 4 digits. How do I avoid the return result to be 9340 (when its actually 934) or 0004 ( just return a 4) and lastly if all 0000 just return a blank cell Examples:1. 70000000010033131500000000000100000000009340000000002. 70000000010033131500000000000100000000000040000000003. 7000000001003313150000000000010000000000000000000000 Results I would like is1. 9342. 43. Blank cell  Read More

​