If Stored ITEM is all numeric, here's one way:
=Trim(Str(Val(Mid(a$, 14))))

The 14 gets you past the "Stored ITEM:" , Val takes the value of stored item
Str converts it to a string and Trim trims off the sign space.

Make sure the field name in the record is B2 and that the control on your
form or report is NOT called B2.

Tom Lake

Sgurdon:

Ok, well sorry - I assumed you knew more about Access.  Let's back up and
discuss a couple things.

You will import your data into a table.  A table stores data and not
formulas.  The only similarity between Access' table and Excel is the fact
they look similar and each box is called a cell.  The similarities absolutely
end there.  Now you are in Access world - things are different and you
accomplish tasks using different objects versus cell or sheet manipulation.

I am not going to explain the details of a table and its design view versus
data view, but you need to conceptualize each row is a record and each column
is a field in that record and you don't/can't store formulas/calculated
values in a table.  Instead we use queries.

In your case you need to create a new query in design view, then add the
table which contains your imported data onto the Layout Area (top part of
query design screen).  The grided area is called the Design Grid.  You drag
fields from tables in the Layout Area down to a column in the Design Grid.  
You also create formulas (referred to as calculated fields in Access) in the
Design Grid.

In your case you do not need to drag any fields down to the design to build
a calculated field.  Your formulas will be built along the same logic used in
Excel, using many of the same function names you used in Excel (except SEARCH
is now what we call InStr).  In Access we don't use the equals sign (=) in
formulas in queries; it is improper syntax.  Just begin typing your formula
in the row labeled Field.

In Access we don't refer to data by using cell intersection names such as
A2, G74; we use field names.  When you write a formula it is assumed/implied
you are working with a record in a table.  You don't reference fields/values
in other records, the context is the one record in the table you are working
with.  Most folks really struggle with this coming from Excel, but it just is.

So anytime you are thinking of referring to cell A1 you would instead type
the field name from the table you are working with in the Layout Area.  
Remember, cell references are a thing of Excel, not Access.  Now you are
working with fields (columns) and records (rows).  Once you enter a formula
in a query it will calculate a value for each record in the table.  There is
no AutoFilling or copying and pasting of formulas.  What you do for one
record is done for all records in a query.

A note about calculated fields:  after you enter your formula, then tab out
of the field or click elsewhere you will notice a name is given to your to
your formula - Expr1:.  This is because in a sense you have created a new
'field' and every field must have a name.  You will notice this name as the
column header where you are used to seeing A, B, C, D, E, F.  You can rename
the field to something meaningful by selecting Expr and overwriting it.  You
will learn in time to do this when entering your formula similar to - Item:
Mid( . . .

See how this helps you, and then come back with additional questions.

Seth Schwarm