Don't need a formula:
1. Select the data
2. Choose Data, Text to Columns
3. Select Delimited, Next
4. Check Space and add _ to Other, then click Next
5. Highlight each column in the Data Preview pane that you don't want and
turn on the option Do not import (Skip) and click finish.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Nikki" wrote:

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

EA_1045_02949_03275 (John Doe)