Concatenation prob
 

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

Try this...

=TEXT(A1&" "&B1&", 2008","d mmm yy")

Rick

Concatenation prob
 

Many thanks Rick and Tom - I'll try both out - auto time sync is set but it
had gone haywire without me noticing - reset now but I suppose we shall be
top of the pops until Jan unless the poating can be deleted?

Francis

(Goodness knows how my PC's time/date got messed up -
"Rick Rothstein (MVP - VB)" 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

Try this...

=TEXT(A1&" "&B1&", 2008","d mmm yy")

Rick