Extract from Second to fift number of a serie

[Fgomez]

Happen that I have a to download a long list from a database coming this
way:
5103-80-3342
5111-85-3342
5210-88-3342...

What I need to do is extract only 3 numbers from every one of them like
this:
103
111
210

Could somebody help me to get this done.

Thanks

Fernando Gomez

 

[Earl Kiosterud]

Fernando,

In another column:
=MID(A2, 2, 3) copied down with the fill handle. This can be converted to
permanent values so you don't need the original stuff any more, or the
formulas

If your data isn't always of the same form, where the 2nd-4th characters are
what you want, you'll have to give more examples of the data.

 

[Fgomez]

Earl,
Thanks you so much, this is exactly what I was looking for.

Fernando