Thanks for the help.

"JE McGimpsey" wrote:

> If the number is always left paren followed by one digit:
>
> D1: =--MID(A1,2,1)
>
> if there may be more digits, but they're always followed by a caret (^):
>
> D1: =--MID(A1,2,FIND("^",A1)-2)
>
>
> In article <7F5E5A74-A9C8-4EE5-B0C8-9E1F312A0E41@microsoft.com>,
> Joe <Joe@discussions.microsoft.com> wrote:
>
> > Is there a formula that will return only partial data from one cell to
> > another?
> > Ex. Cell D1 contains (5^Inlet) And I want to write a formula that will only
> > return the number 5 of cell D1 to Cell A1. Is this possible?

>