MrExcel.com Online Store : Excel Guru : Isnt it Obvious? Duh! White T-Shirt
Isn't it obvious? Use the =TRIM(MID(A2,Find(" ",A2),25)) function and then do a Paste-Special Values. Duh!