Extract from Second to fift number of a serie

  • Thread starter Thread starter Fgomez
  • Start date Start date
F

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
 
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.
 
Back
Top