concatenate problem (SP3 2003)

[steveh]

Morning all

Sorry for all the stupid questions this week but I am having a right mare!!

I am trying to concatenate 2 cells, R2 is formatted as General and R3 is formatted as dd-mmm, R2 = Thu, R3 = 11-Nov I can't change the format because the results come in from a web query

I have tried using =R2& "-" &R3 and I have tried using =concatenate(R2,"-",R3) but both result in Thu-40493 I have tried formarting the cell that is receiving the data as General, Number, Text, Date and Custom but all return the same answer.

[StuartR]

Try
=R2 & "-" & TEXT(R3,"dd-mmm")

[steveh]

Try
=R2 & "-" & TEXT(R3,"dd-mmm")

Hi Stuart

Thanks for looking. With that I get -00-Jan, again I have tried it will all of the different cell formats

[HansV]

Please post a sample workbook.

[steveh]

Please post a sample workbook.

Hi Hans

Thank you for taking a look, please find attached a sample that is formatted the same as the main WB

[HansV]

Cells R2 and R3 are blank. The dates start in column S, so you should use

=S2 & "-" & TEXT(S3,"dd-mmm")

and fill right.

[steveh]

Cells R2 and R3 are blank. The dates start in column S, so you should use

=S2 & "-" & TEXT(S3,"dd-mmm")

and fill right.

I must have stuck another column in without thinking about it. Sometimes your the bat and sometimes your the ball, I have been the ball all of this week, roll on Friday 15:00 so I can get off to the coast

[HansV]

You're going to be a beach ball?