| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combining Text and formula
I am trying to combine and formula with text. I have a link to another cell
which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Text and formula
='Write Time Capacity'!$D$20&" % hours"
-- David Biddulph "Mitchell" wrote in message ... I am trying to combine and formula with text. I have a link to another cell which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Text and formula
='Write Time Capacity'!$D$20&"% hours"
-- Hth Kassie Kasselman "Mitchell" wrote: I am trying to combine and formula with text. I have a link to another cell which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Combining Text and formula
Thanks for the fast help
"kassie" wrote: ='Write Time Capacity'!$D$20&"% hours" -- Hth Kassie Kasselman "Mitchell" wrote: I am trying to combine and formula with text. I have a link to another cell which will produce a number and I want to follow it with some descriptive text. ='Write Time Capacity'!$D$20 % hours The % hours should be text while the formula will return a number. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from a Cell to a text box. | Excel Worksheet Functions | |||
| Converting text string back into a formula | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
