| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Insert info from a cell into text
Using Excel 2003 one of my end users has a cell that contains text such as
"Jane Doe holds 5% of Widgets". She would like to have the reference to 5% be variable based on the results in a formula from a different cell. Is this possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert info from a cell into text
="Jane Doe holds " & A1 & "% of Widgets"
"Richard" wrote: Using Excel 2003 one of my end users has a cell that contains text such as "Jane Doe holds 5% of Widgets". She would like to have the reference to 5% be variable based on the results in a formula from a different cell. Is this possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert info from a cell into text
In say, C2: ="Jane Doe holds "&TEXT(B2,"0%")&" of Widgets"
where B2 houses the formula calculating the percentage -- Max Singapore http://savefile.com/projects/236895 Downloads:25,000 Files:300 Subscribers:70 xdemechanik --- "Richard" wrote: Using Excel 2003 one of my end users has a cell that contains text such as "Jane Doe holds 5% of Widgets". She would like to have the reference to 5% be variable based on the results in a formula from a different cell. Is this possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Insert info from a cell into text
="Jane Doe holds " & TEXT(A1,"0.0%") & " of Widgets"
If this post helps click Yes --------------- Jacob Skaria "Richard" wrote: Using Excel 2003 one of my end users has a cell that contains text such as "Jane Doe holds 5% of Widgets". She would like to have the reference to 5% be variable based on the results in a formula from a different cell. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert info only if cell is blank (Max from Singapore ref) | Excel Discussion (Misc queries) | |||
| insert drop-down list without existing cell info | Excel Discussion (Misc queries) | |||
| If specific text result,... corresponing cell info in another colu | Excel Worksheet Functions | |||
| Copy and insert cell info macro help | Excel Discussion (Misc queries) | |||
| Need a macro to insert text in a cell that already has text.Excel | Excel Discussion (Misc queries) | |||
Linear Mode
