View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default Formula for Pulling partial data from one cell into another

Is there a formula I can use to pull only some data from a cell into
another?
C11 contains: 0.10 0.42%
I want C4 to contain: 0.10
I want D4 to contain: 0.42%

I would appreciate the help and if there is a formula I would really love
to
understand what it means and how it works. Thanks!


These work...

In C4: =LEFT(E15,FIND(" ",E15)-1)

In D4: =RIGHT(E15,LEN(E15)-FIND(" ",E15))

Rick