Excel cell, reference to another cell 2

[stormcloudgathering]

I have a cell (say a1) which has the text "Capex" in it, I would like to refer to a date in another cell (say c1, the date being 04/03), so that the result in cell a1 looks like this "Capex" - 04/03
Is this possible, and if so, please can someone tell me how to do it?
Many thanks

lynne

 

[xlbo]

In A1
="Capex - " & text(C3,"mm/yy&quot

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[krinid]

Sounds like you may be best off dabbling into some VBA, in which case it's easy, just by using the Worksheet_Change event.

But in straight Excel, I don't think it's possible to directly enter in a value in A1 and then have Excel append the contents of another cell to it.

The example Geoff gave you will ALWAYS show "Capex" in A1. And if you decide to change the contents of A1, you'll lose the date unless you enter in the text again as shown above.

However, if you allow THREE cells... it's easy !

in A1
=B1 & " - " & Text (C3, "mm/yy&quot

in B1, enter in the 'text' you want to displayed before the date

in C1, enter the date you want displayed.

 

[stormcloudgathering]

Big snogs for both of you, thank you so very much
lynne