T4molie

Guys,

If I've got "JAN" in cell A2 and "2007" in cell C2 and in cell E2 I want to it to have "JAN-07". Is there a way of doing this?

Using Excel 97

Cheers

Andy

MrShades

Try putting this in cell E2

=CONCATENATE(A2,"-",C2)

T4molie

MrShades,

That does kind of work but it gives me "JAN-2007". I'm looking for it to create "JAN-07"

Andy

GazTheHat

Try:

=CONCATENATE(A2,"-",RIGHT(C2,2))

T4molie

Nice one Cheers Gaz

Andy

Frosty The Snowman

A quick on topic question about this for me too, can you actually get the result to read as a proper date, for formatting purposes. Sure I had problems trying to do this when I had a cell with 1061231 in representing the date
backwards with a 1 in front.

Thanks

michaelro

Assuming your date is in Cell A1 and looks like this 1061231 then the following should work:

=DATEVALUE(MID(A1,6,2) & "/"& MID(A1,4,2)& "/"&MID(A1,2,2))

Go to Format Cells and select a Date category.

dsmith

just to say - there is an alternative to concatenate - you can us "&" to "add" strings.

i.e.

+A2&"-"&RIGHT(C2,2)

Frosty The Snowman

Thank you very much sir

That will no doubt make my life just that little bit easier