linking several cells into one

[Guest]

I am trying to have the following cells link together to look like:
RS0001_19671109


A2(RS) B2(0001) C2(1967-11-09)

is there some kind of formula i can use?
Please help!

 

[Guest]

Have a look at the CONCATENATE function.
--
John
MOS Master Instructor
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[Guest]

Assume B2 and C2 are text value

=CONCATENATE(A2,B2,"_",SUBSTITUTE(C2,"-",""))

 

[Guest]

Try:
=A2 & B2 & "_" & SUBSTITUTE(C2, "-", "")

Regards,
Greg

 

[T. Valko]

I'm assuming C2 is a true Excel date in the format yyyy-mm-dd

=A2&B2&"_"&TEXT(C2,"yyyymmdd")

Biff

 

[Rowland]

If you need to get rid of the parenthesis in the cells then try
=SUBSTITUTE(SUBSTITUTE(A2&B2,"(",""),")","")&"_"&SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"(",""),")",""),"-","")