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.

 

[offthelip]

Is it always 3 digits and a dash that you want removed from the front of the social security number, or can the number of digits vary , e.g. 45-45-6789

 

[Michael M]

Try

=B1&" "&Right(A1,7)

 

[offthelip]

try;
=B1& " " &MID(A1,5,255) or
or
=B1 & " " & MID(A1,FIND("-",A1)+1,255)

 

[NY_Rican]

I need the end result to be the name, followed by the last 6 digits of the SSN, with the dash between (45-6789)

 

[NY_Rican]

I need the end result to be the name, followed by the last 6 digits of the SSN, with the dash between (45-6789)

I think I am making it difficult. A1 can be the name and B1 the SSn

 

[Rick Rothstein]

Is the Social Security Number enclosed in parentheses the way your post seems to show?

Is the Social Security Number in the cell the way you show or do you have a 9-digit number in the cell and add the dashes (and maybe the parentheses) using cell formatting?

 

[NY_Rican]

Try

=B1&" "&Right(A1,7)

That works with "6" instead of "7", but I need that "-" between the first 2 digits and the last 4

 

[NY_Rican]

Is the Social Security Number enclosed in parentheses the way your post seems to show?

Is the Social Security Number in the cell the way you show or do you have a 9-digit number in the cell and add the dashes (and maybe the parentheses) using cell formatting?

The social shows..."123-45-6789"

 

[jtakw]

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)