Text added to formula?

[Ltat42a]

Hi All, I thought I saw a way of adding some text to a formula.
I have a spreadsheet with 2 worksheets, sheet 1 is page 1, sheet 2 is page 2.
On sheet 1, cell D3 I type in the date. On sheet 2, I use this - =IF('Front Page'!D3="","",'Front Page'!D3) - which works real well.

The result is "Tuesday, May 6, 2008". I'd like to add "- A-Shift" to the right of the date, so that it displays Tuesday, May 6, 2008 - A-Shift.

Is this possible?

Thanx...Lt

[Trebor76]

Ltat42a,

Try this:

=IF('Front Page'!D3="","",'Front Page'!D3 & " - A-Shift")

HTH

Robert

[Ltat42a]

Thanx for the reply, I'm getting this result now - 39574-A-Shift. I have the cell fornatted for "Tuesday, May 6, 2008".

I'm using Excel 2003.

Lt

[Trebor76]

Ah, becuase there's text mixed in, the date part of the string has to be formatted manually, i.e

=IF('Front Page'!D3="","",TEXT('Front Page'!D3,"dddd, mmm d, yyyy")&" - A-Shift")

HTH

Robert

[Ltat42a]

Yeah, that worked good, Thanx again for the reply.

LT

[Trebor76]

Thanks for the feedback and you're welcome :-)