One way:

=MID(D3,FIND(" ",D3)+1,100)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Jambruins" wrote in message
...
how would I change the formula to pull everything to the right of the
space?

"Dave O" wrote:

This formula
=MID(D3,1,FIND(" ",D3,1)-1)
.... looks for the space in between the numbers, and pulls everything to
the left of the space.