Hi,
We need to know how the current data appears in the cells.
for example, 10 - 12
Is that 10 in column A, - in Column B, and 12 in Column C? or the whole lot in
one cell?
Perhaps if you attach a file with some sample data, it would be helpful.
Regards - Dave.
> Date: Tue, 28 Oct 2008 21:12:24
You can run the following macro assuming that your texts are in column-A. If
it differs, change the program accordingly. Hope it helps.
Option Explicit
'-
Sub txt2arr()
'Assuming that all the texts are in column-A
'This program will fill the subsequent c
Hi use this function : =A1&" "&B1&" "&TEXT(C1,"dd-mmm-yy")
where A1 = MS
B1 = Excel
C1 = 29-0ct-08
On Fri, Oct 24, 2008 at 11:31 AM, H Upadhyay <[EMAIL PROTECTED]>wrote:
> Pls chk attached file
>
> Regards
> Harish Upadhyay
>
>
>
> On 10/23/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>>
>
Dear All ,
I am the beginnar of vba .I never have exposured of seeing very good and
complex kind of application of xl that built with vba code.So please send me
some of good xl books that have lot of vba codes to follow .
I m realy great full to you .
Allah Hafiz ,Kamran Haider . > Date: T
give me some time till I code one for you
Ajit
On Wed, Oct 29, 2008 at 9:42 AM, <[EMAIL PROTECTED]> wrote:
>
> Hi, I need help with a spreadsheet. The spreadsheet is created using a
> program I have no control over. I have a column that can contain weeks
> that a course is run. It seems to c
