Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
In cell F2 of a sheet named "main flash" I want to have it display the following: "for week 42 ending" The week 42 part would come from another sheet named "actuals" that's in the same workbook. -- Weasel ------------------------------------------------------------------------ Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206 View this thread: http://www.excelforum.com/showthread...hreadid=525683 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
Hi
You could do something like this: ="for week "&E2&" ending" Andy. "Weasel" wrote in message ... In cell F2 of a sheet named "main flash" I want to have it display the following: "for week 42 ending" The week 42 part would come from another sheet named "actuals" that's in the same workbook. -- Weasel ------------------------------------------------------------------------ Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206 View this thread: http://www.excelforum.com/showthread...hreadid=525683 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
="for week " & actuals!x99 & " ending"
You could even do: ="Please pay me by: " & text(a1,"mm/dd/yyyy") to get the formatting the way you want. Weasel wrote: In cell F2 of a sheet named "main flash" I want to have it display the following: "for week 42 ending" The week 42 part would come from another sheet named "actuals" that's in the same workbook. -- Weasel ------------------------------------------------------------------------ Weasel's Profile: http://www.excelforum.com/member.php...o&userid=27206 View this thread: http://www.excelforum.com/showthread...hreadid=525683 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
would the same formula/method apply for making a chart haeading label responsive? My chart is driven by the vaue of A1 which is defined by a combo box. I would like the chart heading to look something like = "estimated VAT For" & A1 -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=525683 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
Hi
I don't think so. Have a look here for a pretty exhaustive site on charts: http://www.contextures.com/JPChartIndex.htm Andy. "cereldine" wrote in message ... would the same formula/method apply for making a chart haeading label responsive? My chart is driven by the vaue of A1 which is defined by a combo box. I would like the chart heading to look something like = "estimated VAT For" & A1 -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=525683 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
cereldine wrote
would the same formula/method apply for making a chart haeading label responsive? My chart is driven by the vaue of A1 which is defined by a combo box. I would like the chart heading to look something like = "estimated VAT For" & A1 The way I accomplished this was to tuck the source for the chart title away in a cell (say B30) in a hidden row (30) and then refer the chart title box to that: B30 ="estimated VAT For" & A1 Chart Title reference: =Sheet1!B30 <--Sheetname needed for some reason. Once you place your formula in the cell you will eventually hide (for cosmetic reasons), you can click the Chart Title box, type =, and click the cell with the formula and the sheet name will automatically be added. Hope I haven't confused you too much. -- David |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you put a formula in the middle of text?
Thanks David, works a treat for anyone else looking to have more informative charts -- cereldine ------------------------------------------------------------------------ cereldine's Profile: http://www.excelforum.com/member.php...o&userid=32069 View this thread: http://www.excelforum.com/showthread...hreadid=525683 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to formula - Help pleaaase | Excel Discussion (Misc queries) | |||
text in formula explaining formula not to print | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Using the text from a cell as a range name in a formula | Excel Discussion (Misc queries) | |||
Concatenation formula loses text wrap formatting | Excel Discussion (Misc queries) |