Formula for Pulling partial data from one cell into another

J

Jamie

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!
 
R

Rick Rothstein \(MVP - VB\)

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!
Click to expand...

These work...

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

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

Rick
 
K

Ken Johnson

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!
Click to expand...

Formula in C4...
=VALUE(MID(A1,1,FIND(" ",A1)-1))

Formula in D4 formatted Percentage...
=VALUE(MID(A1,FIND(" ",A1)+1,255))

Ken Johnson
 
H

Harimau

A cheap and dirty way instead of using columns is to use the handy "Text to
columns" tool in Excel, and using space as a seperator.
 
Top