Extract Text from a String. Mid, Find, Len function.

[srizki]

Hi all,

I have the following in column A.
[TABLE="width: 1069"]
<tbody>[TR]
[TD]S:\Houston JIB Accounting\Outside Operated JIB's\Julie's Group JIBs\SOHAIL UPLOADS\SMR America Production Co\07-2017\0717-0070029323.xlsm

and I would like to extract 0070029323 from the string. The position of the text is always the same. it ends before the 5 characters and it is always 10 characters long.

Please advise.

[/TD]
[/TR]
</tbody><colgroup><col></colgroup>[/TABLE]

 

[SpillerBD]

=mid(a1,len(a1)-4-10,10)

 

[Fluff]

Alternatively
=LEFT(RIGHT(A1,15),10)

 

[srizki]

Thank you, the both formula worked they way I wanted it.
Great.

 

[Fluff]

Glad we could help & thanks for the feedback