Concatenation prob
 

=DateValue(A2 &" "&B2&", 2008")

in D2. format D2 to display the date in the format you want.

Then you can drag fill. then select D and do Edit=Copy, then do
Edit=Paste Special and select values.

if you don't need a real date and don't want to format the cell

=Text(DateValue(A2 &" "&B2&", 2008"),"d mmm yy")

--
regards,
Tom Ogilvy


"Francis Hookham" wrote:

A visually handicapped friend is secretary of his club.

He receives a list of events on a spreadsheet where the date is given as
follows:



Col A contains "Jan"

Col B contains "1"

Col C contains "Tuesday" (which is superfluous in this operation)

We know the year is 2008



I am having difficulty in concatenating "1" and "Jan" and "08" into Col D,
formatted as "d mmm yy", so I can do away with Cols A-C



(Not decided yet whether to simply drag a fromua down the cut and past
values back, or the run a macro which might save time in long run because it
could delete empty rows at same time)



Please help, it's going to take me hours by hand otherwise.



Francis Hookham