| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying data from 2 cells into 1
I have a different formula in 2 different cells, and I would like to combine
the responses into 1 cell. Q92 has a percentage output and R92 has a text output. I would like E92 to be the % from Q92 and the text from R92 so that the result in E92 is 6% Net 75, for one example. Any advice would be appreciated. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying data from 2 cells into 1
Try this:
=TEXT(E92,"0%") & " " & R92 Hope this helps. Pete "Taylor" wrote in message ... I have a different formula in 2 different cells, and I would like to combine the responses into 1 cell. Q92 has a percentage output and R92 has a text output. I would like E92 to be the % from Q92 and the text from R92 so that the result in E92 is 6% Net 75, for one example. Any advice would be appreciated. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying data from 2 cells into 1
Thanks, Pete. That helped.
"Pete_UK" wrote: Try this: =TEXT(E92,"0%") & " " & R92 Hope this helps. Pete "Taylor" wrote in message ... I have a different formula in 2 different cells, and I would like to combine the responses into 1 cell. Q92 has a percentage output and R92 has a text output. I would like E92 to be the % from Q92 and the text from R92 so that the result in E92 is 6% Net 75, for one example. Any advice would be appreciated. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying Filter Data & Using for each in cells | Excel Discussion (Misc queries) | |||
| copying only cells in a filter with data | Excel Discussion (Misc queries) | |||
| copying data to different Cells | Excel Worksheet Functions | |||
| Copying Data Between Cells | Links and Linking in Excel | |||
| Automatic copying of data cells | Excel Discussion (Misc queries) | |||
Linear Mode
