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

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

Biff

"jackiel_82" wrote in message
...
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!