linking several cells into one

J

jackiel_82

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!
 
J

john the confused

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)
 
T

Teethless mama

Assume B2 and C2 are text value

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

T. Valko

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

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

Biff
 
R

Rowland

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