TEXT & DATES & CONCATENATE

F

Finance Guru

Hello Community members,
I am using Excel 2007
Question - How can I display the following

A1 = Text ( Financial Results as at
A2 = date = 31/05/2009

so that it would appearas follows : Financial Results as at 31/05/2009
with a space after "at" and 31/05/09

Hope you can help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calc Date Based on Year 3
how to set reminder? 3
Looking up across date ranges in Access 2
Dates - gaps between 3
date range 11
Trouble Using Count Feature for Multiple Criteria 3
Sumproduct with added days 2
sumproduct with additions to data 1

Top