Concatenating a Text string with a date - slight problem

[Barking_Mad]

Hi

I'm using the following successfully:

=$F2&TEXT($G2," dd/mm/yy")

However, if the date cell at $G2 is blank it's still showing a date tagged on to the end of the text, albeit it as: 00/01/00

Any ideas how if the date cell is blank I can just get it to not show anything at all?

Ta

[estige]

Maybe
=IF($G2="","",$F2&TEXT($G2," dd/mm/yy"))

[Fotis1991]

Try

=IF ($G2="","",$F2&TEXT($G2," dd/mm/yy"))

[Barking_Mad]

Hi,

Sorry, poorly explained by myself in the first post.

I still want it to use the text present in $F2, but I dont want to add 00/01/00 on the end if $G2 is blank.

[Fotis1991]

=IF($G2="",$f2,$F2&TEXT($G2," dd/mm/yy"))

[Barking_Mad]

Thanks

One further question as a result of this....Im referencing the concatenated cell ($H2) in another worksheet. However the text&date in the one cell means the referenced cell is showing as: 41443 (which is actually 18/06/13) and it's missing the concatenated text from the cell. Any ideas of a way round this?

[Fotis1991]

Looks very strange....

As usual...i have to ask for a small sample workbook.

[Barking_Mad]

Hi,

No need, i was referencing the wrong column with VLOOKUP so it was returning the date. DOH! *slaps self*

Thanks Fotis

[Fotis1991]

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.