Joining Cells...

[NY_Rican]

Joining Cells...A1 has social security numbers (123-45-6789). B1 has the name John Doe. I want C1 to be "John Doe 45-6789". Thank you all.

 

[NY_Rican]

Hi,

It sounds to me like your SSNs are just a 9 digit number formatted as SSN.

Try one of these:

Book3.xlsx
	A	B	C	D	E	F
1	123-45-6789	John Doe		John Doe 45-6789		John Doe 45-6789
Sheet937

Cell Formulas
Range	Formula
D1	D1	=B1&" "&REPLACE(RIGHT(A1,6),3,0,"-")
F1	F1	=B1&" "&MID(A1,4,2)&"-"&RIGHT(A1,4)

That's the one !!!! I just switched the A1 and B1, Thank you. The REPLACE

 

[Rick Rothstein]

That's the one !!!! I just switched the A1 and B1, Thank you. The REPLACE

If that is what you were after, then here is another way to do it...

=REPLACE(TEXT(B1,"000 00-0000"),1,3,A1)

 

[jtakw]

That's the one !!!! I just switched the A1 and B1, Thank you. The REPLACE

You're welcome, thanks for the feedback.