Combine day text and date problems
=a1&text(a2,"m/d/yyyy")
or
=a1&char(10)&text(a2,"m/d/yyyy")
(with wrap text checked)
mike wrote:
Hi,
I have the day of the week in A1 and the date in A2 and I'm trying to
combine them in A3 so it's appear as "10/1/08 Wednesday" but when I apply
the formula it comes out as (please see below in results). How can I do it
so it'll come out the way i want?
A1: Wednesday
A2: 10/1/2008
Results: Wednesday 39722
--
Dave Peterson
|