I'm querying external data from Excel using Microsoft Query. I'm querying an
oracle database. I'd like to limit the amount of records that come accross
so the file is easier to manage. We have 9 digit sales part numbers. Each
digit has significance. I'd like to isolate three characters, 4-6, and bring
only those records where these digits are equal to 123. I tried adding a
column in Microsoft Query, but was unable to make a mid function work.

Is there any hope? I'd prefer to use Excel query tool due to the
limitations of linked tables with Microsoft Access, and ultimately we need
the report in Excel so it is useful to the end user.