=DATEVALUE(b2 &"-"&a2)
or
=DATEVALUE(b2 &"-"&a2&"-"&8)
then format as desired
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Francis Hookham" wrote in message
...
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

Of course, You will need to change the result to a value before deleting the
original columns.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
=DATEVALUE(b2 &"-"&a2)
or
=DATEVALUE(b2 &"-"&a2&"-"&8)
then format as desired
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Francis Hookham" wrote in message
...
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