View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Jambruins
 
Posts: n/a
Default Split text without using data-text to columns

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.