How to extract numbers from within a string of numbers

[BrettOlbrys1]

Good morning. I have a long column of data (thousands) with a series of account numbers, such as 00110901101100000. I need to extract numbers in the 4th thru 7th positions (which I highlighted) so I can match these accounts to cost center descriptions.

How do I do this?

Thanks

Brett

 

[Fluff]

How about

=MID(A2,4,4)

 

[BrettOlbrys1]

How about

=MID(A2,4,4)

So I understand the formula, it is looking within a number string and returning the 4 numbers that start in the 4th position?

 

[Fluff]

That's right.