Formula for Pulling partial data from one cell into another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!
 
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
 
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I need to add multiple cells then subtract them from one cell c4+c6+c7+c9+c10+c11 and subtract them 1
Multiple IF statements looking up multiple ranges. 7
Pulling Data from one worksheet into another 1
Stripe out duplicate data 5
SUMPRODUCT formula I think w/ wild card & number vs number as text 8
Conditional formatting multiple cells from one cell to another 3
Using cell contents in Vlookup formula 3
Using and IF formula for a cell value between two amounts 4

Back
Top