| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and formula within the same cell
Hi. I want to include text and formula within the same cell in Excel.
Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
=a4*b7 +N("membership") + c3*d10 +N("Journals")
works with numbers. And something like: =A1 & " " & b1 & TEXT("this is a comment",";;;") will work when you want to return Text. Lucy wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
=A4*B7&" Membership "&C3*D10 &" Journals"
"Lucy" wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
Maybe this.......
=A4*B7&" Membership + "&C3*D10 &" Journals" Vaya con Dios, Chuck, CABGx3 "Lucy" wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
Sorry, I mis-read your post.....probably this will do as you wish.....
=(A4*B7)+(C3*D10)+N("Membership + Journals") hth Vaya con Dios, Chuck, CABGx3 "CLR" wrote: Maybe this....... =A4*B7&" Membership + "&C3*D10 &" Journals" Vaya con Dios, Chuck, CABGx3 "Lucy" wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
It would probably be better to use a standard formula like
=(A4*B7)+(C3*D10) and then insert a comment to explain the formula (right click cell - insert comment). I don't think you can add notes to a formula inside the formula. "Lucy" wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
Sloth
It is possible to add explanatory notes inside a formula. Look at Dave P's post or see below........... =a2*a1+n("my wage+bonus-4 weekly loan repayments") The text after the n will show in the formula bar but not in the cell. Gord Dibben MS Excel MVP On Thu, 21 Sep 2006 07:18:03 -0700, Sloth wrote: It would probably be better to use a standard formula like =(A4*B7)+(C3*D10) and then insert a comment to explain the formula (right click cell - insert comment). I don't think you can add notes to a formula inside the formula. "Lucy" wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formula within the same cell
Thank you to everyone who replied
Lucy Gord Dibben wrote: Sloth It is possible to add explanatory notes inside a formula. Look at Dave P's post or see below........... =a2*a1+n("my wage+bonus-4 weekly loan repayments") The text after the n will show in the formula bar but not in the cell. Gord Dibben MS Excel MVP On Thu, 21 Sep 2006 07:18:03 -0700, Sloth wrote: It would probably be better to use a standard formula like =(A4*B7)+(C3*D10) and then insert a comment to explain the formula (right click cell - insert comment). I don't think you can add notes to a formula inside the formula. "Lucy" wrote: Hi. I want to include text and formula within the same cell in Excel. Does anyone know how I can do it? I am trying to acheive (A4*B7)membership+(C3*D10)journals so it appears as a number (say 100) but anyone looking at the formula can see what it relates to. Can anyone help please? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
