On Fri, 14 May 2010 13:15:01 -0700, Nikki
wrote:

What formula could I use to pull 03275 from the below contents of a cell?

EA_1045_02949_03275 (John Doe)

The following formula will pull characters 15 to 19 from the string in
A1:

=MID(A1,15,5)

Is that what you need?

The following formula will pull all characters between the rightmost
"_" and the next " ", assuming the result is within the 30 first
characters of the string:

=MID(A1,MAX(IF(MID(A1,ROW(1:30),1)="_",ROW(1:30))) +1,FIND(" ",
MID(A1,MAX(IF(MID(A1,ROW(1:30),1)="_",ROW(1:30)))+ 1,
MAX(IF(MID(A1,ROW(1:30),1)="_",ROW(1:30)))+1))-1)

Note this is an array formula that must be confirmed by
CTRL+SHIFT+ENTER rather than just ENTER.

Is that what you want?

As you see, you have to provide more information on the possible
format of the original string in order not to have us to guess what
you mean and to propose a formula that is as simple as possible, but
still working.

Hope this helps / Lars-Åke