| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Pulling partial data from one cell into another
=TEXT(C4,"0.00")&" "&TEXT(D4,"0.00%")
"Jamie" wrote: 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! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Pulling partial data from one cell into another
Ignore the previous reply
"Jamie" wrote: 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! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Pulling partial data from one cell into another
On Jun 1, 7:05 am, Jamie wrote:
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! Formula in C4... =VALUE(MID(A1,1,FIND(" ",A1)-1)) Formula in D4 formatted Percentage... =VALUE(MID(A1,FIND(" ",A1)+1,255)) Ken Johnson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for Pulling partial data from one cell into another
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. "Jamie" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling data from another worksheet thru a formula | Excel Discussion (Misc queries) | |||
| remove partial data from cell | Excel Worksheet Functions | |||
| Formula partial result displayed in cell | Excel Discussion (Misc queries) | |||
| formula to extract partial content (text) of cell | Excel Discussion (Misc queries) | |||
| Bringing partial data from one cell into another | Excel Worksheet Functions | |||
Linear Mode
