Concatenation prob
 

Hi Francis,

Please fix your system Date/Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|
|

Concatenation prob
 

You didn't read Francis' second posting...

Rick



"Niek Otten" wrote in message
...
Hi Francis,

Please fix your system Date/Time

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"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
|
|

Concatenation prob
 

I feel ashamed!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rick Rothstein (MVP - VB)" wrote in message ...
| You didn't read Francis' second posting...
|
| Rick
|
|
|
| "Niek Otten" wrote in message
| ...
| Hi Francis,
|
| Please fix your system Date/Time
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "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
| |
| |
|
|
|

Concatenation prob
 

| Please fix your system Date/Time
|
| You didn't read Francis' second posting...

I feel ashamed!

Don't worry about it... if your newsreader supports it, you will see that I
just took the future-dated message off of the top of the listing.

Rick

Concatenation prob
 

Too much of the puffy with the Walk?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Niek Otten" wrote in message
...
I feel ashamed!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Rick Rothstein (MVP - VB)" wrote in
message ...
| You didn't read Francis' second posting...
|
| Rick
|
|
|
| "Niek Otten" wrote in message
| ...
| Hi Francis,
|
| Please fix your system Date/Time
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "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
| |
| |
|
|
|