Here is the fancy version...

=LEFT(MID(A1, FIND("^", SUBSTITUTE(A1, "_", "^",
LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))))+1, 256), FIND(" ", MID(A1, FIND("^",
SUBSTITUTE(A1, "_", "^", LEN(A1)-LEN(SUBSTITUTE(A1,"_",""))))+1, 256)))
--
HTH...

Jim Thomlinson


"Jim Thomlinson" wrote:

Assuming the format and text lenght of the ID to always be the same then
=MID(A1, 15, 5)
If you need to seach for the text between the last _ and the first balnk
then we need to get a bit fancy...
--
HTH...

Jim Thomlinson


"Nikki" wrote:

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

EA_1045_02949_03275 (John Doe)