View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lai704 Lai704 is offline
external usenet poster
 
Posts: 9
Default How to split number and text string to separate cells?

I have in cells A1:A1000....a combination of number and text, ex.."123 abc abc"

I wanted to split into 2 separate cells...I've done the number part...using
"=LEFT(A1,FIND(" ",A1))" to cell B1

but I can't seem to figure out how to split out "abc abc" to C1?

Any help is appreciated.

Thanks.