concatenation

[Blake 7]

hi guys - I have used some helper columns (but not very effectively) to get what I want from a data set which I have received.

Col I of the attached shows what I really want... could someone show me a more efficient method please as i'm embarrassed by this!! ? many thanks

[Moo the Dog]

I am entirely unsure of what exactly you want. It seems that Column I is simply a date range from April 1 thru May 5th - with no basis or regard for what is in the day, month or year columns.

Perhaps I am missing something?

- Moo

[Blake 7]

Hi Moo... thanks for your response and for taking the time to look at my issue. Most kind.

If you see my helper cols, e, f and g, and then the concatenation of e, f and g in col h. This is what i am trying to achieve but in the format of col I.

Basically... it the first two characters of col a, col b as a number and the last two characters of col c. to make a date formatted as dd/mm/yy

Is that clear?

Many thanks again for looking

[Glenn Kennedy]

Something odd in rows 33 & 35. I assume that these are a mistake (I reformatted A as General to make viewing easier). is this getting close??

[Glenn Kennedy]

I just noticed you wanted yy. Amended.

[Blake 7]

Hey Glenn - how's it going. I'll take a look now. Cheers mate

[Blake 7]

Hi mate - thats perfect...many thanks once again for helping me out, very kind of you. I try to help where i can but as a novice....!!!

What on earth is going on in those rows i wonder 33 and 35 how bizzare!

[Glenn Kennedy]

You're welcome!! I must go and plant some leeks...

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.