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)

To extract the value between the last underscore, and the following <space:

=TRIM(LEFT(SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(
A1,"_",REPT(" ",99)),99))," ",REPT(" ",99)),99))

--ron