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

Regards,
Greg

"jackiel_82" wrote:

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!