Day & Date in one cell

[bern]

Hi All
I hear you all say ‘that's simple just Concatenate the two cells’ but...... I cannot

I have a order form worksheet which generates orders and puts them into a database, also I have a records worksheet that reads the info from that database using a Vlookup function.

The day and date required for delivery is in 2 separate cells in the database, how can I have that day and date into 1 cell in the records worksheet i.e.
=VLOOKUP($E$10,Database,42) and =VLOOKUP($E$10,Database,43)

Any help appreciated
Bern

[oldchippy]

Hi All
I hear you all say ‘that's simple just Concatenate the two cells’ but...... I cannot

I have a order form worksheet which generates orders and puts them into a database, also I have a records worksheet that reads the info from that database using a Vlookup function.

The day and date required for delivery is in 2 separate cells in the database, how can I have that day and date into 1 cell in the records worksheet i.e.
=VLOOKUP($E$10,Database,42) and =VLOOKUP($E$10,Database,43)

Any help appreciated
Bern

Hi Bern,

Try this, if "Day" is in A1 and "Date is in B1, then this in C1

=TEXT(A1,"dddd")&" "&TEXT(B1,"dd/mm/yy")

oldchippy

[bern]

Hi
Thanks for the responce

It did help as I used your formula in the Order sheet thus giving me desired result
Many thanks
Bern