Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a cell that contains text and a data reference?
I believe there is a way to set up a cell so that I can have text and a
formula in the same cell. For example, I want to have a cell say "for the period ended (ref)". and the reference would be to another cell on the worksheet. any help? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a cell that contains text and a data reference?
Not sure exactly what you mean but in any cell
="for the period ended "&A1 would concatenate whatever was in A1 to the end of the string. Does that work? Mike "Melanie" wrote: I believe there is a way to set up a cell so that I can have text and a formula in the same cell. For example, I want to have a cell say "for the period ended (ref)". and the reference would be to another cell on the worksheet. any help? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a cell that contains text and a data reference?
"for the period ended "&Sheet2!A1
"Melanie" wrote: I believe there is a way to set up a cell so that I can have text and a formula in the same cell. For example, I want to have a cell say "for the period ended (ref)". and the reference would be to another cell on the worksheet. any help? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a cell that contains text and a data reference?
Hi Melanie,
If the (ref) part is a date, you will need use something like the following formula: ="For the period ended " & DAY(B1)&"/"&MONTH(B1)&"/"&YEAR(B1) Where B1 is the cell with the ref in it. Otherwise, excel will just display the date as a number e.g. "For the period ended 86928" Cheers - David |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a cell that contains text and a data reference?
Or just:
="For the period ended " & text(b1,"dd/mm/yyyy") Daveo wrote: Hi Melanie, If the (ref) part is a date, you will need use something like the following formula: ="For the period ended " & DAY(B1)&"/"&MONTH(B1)&"/"&YEAR(B1) Where B1 is the cell with the ref in it. Otherwise, excel will just display the date as a number e.g. "For the period ended 86928" Cheers - David -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting up a cell that contains text and a data reference?
Aaah! Cheers for that Dave. I couldnt find the worksheet function
equivalent of Format(). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting a cell reference in one sheet that updates a workbook? | Excel Discussion (Misc queries) | |||
How do I reference data from a sheet specified by text in a cell | Excel Worksheet Functions | |||
Setting Precision when using &"Characters"& in a cell reference | Excel Discussion (Misc queries) | |||
Using a Text / Data output as a cell reference | Excel Discussion (Misc queries) | |||
How can I reference data or text within a text box to a cell in Ex | Excel Discussion (Misc queries) |