Code that picks numbers out from a set

[jhenry330]

Hello,

I have a cell in the same place in multiple excel files that reads like these for example:

8-2157-2
6-1245-3
4569-1
2536-2
8745-15

I'm trying to find some code that will pick the four digits that are together without dashes in order to use it as a row number in another excel sheet I'm making. Any ideas if this is possible?

Thanks in advance!

-jeff

[FDibbins]

will the entries always be in that format?
x-xxxx-x
xxxx-x
could you have x-xxxx?

if you know the path and file names of the other files, you could probably do something like this...
=MID([file1.XLSX]Sheet4!$A$2,IF(LEN([file1.XLSX]Sheet4!$A$2)-LEN(SUBSTITUTE([file1.XLSX]Sheet4!$A$2,"-",""))=2,3,1),4)

[jhenry330]

Thanks for the reply!

They would never be "x-xxxx".

[FDibbins]

OK good, did you try my suggested formula?

[jhenry330]

I did! It works! Thank you! Any idea of doing it in VB? I may just assign a cell to do this formula, then call it from VB...