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)