One way.

=MID(A1,FIND(CHAR(32),A1)+1,FIND(CHAR(32),A1,FIND( CHAR(32),A1)+1)-FIND(CHAR(32),A1)-1)

If this post helps click Yes
---------------
Jacob Skaria


"Wanna Learn" wrote:

Hello How Do I extract anything after the first word example column AU
reads Massapequa 5 Prime so in this instance I want to extract 5 prime
this is my messed up formula =TRIM(MID(AU4,SEARCH(" ",AU4)+3,255)) I get
PRIME . Thanks