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?

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?

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?

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

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

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().