If you need to get rid of the parenthesis in the cells then try
=SUBSTITUTE(SUBSTITUTE(A2&B2,"(",""),")","")&"_"&S UBSTITUTE(SUBSTITUTE(SUBSTITUTE(C2,"(",""),")","") ,"-","")
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!