Change number format

[da]

hello
Is there a way to change the SS# in the following format from an existing
table of SS#?
99-999-9999
change to
xx-xxx-9999
Thanks

 

[Jacob Skaria]

I am not sure is this what you are looking for. If not post more examples.

="XX-XXX"&MID(A1,FIND("-",A1,FIND("-",A1)+1),LEN(A1))

If this post helps click Yes

 

[Luke M]

It looks like you're trying to hide the digits? Could use something like:

="xx-xxx-"&RIGHT(A2,4)

 

[da]

I am not sure I understand the formula. I tried it and I got an error #N/A.
Is there any other way, more simple formula?
You can use any numbers as long as they are in SS# format, e.g. 123-45-6789
Thank you

 

[Jacob Skaria]

Type your number in A1
In B1 enter the below formula
="XX-XXX"&MID(A1,FIND("-",A1,FIND("-",A1)+1),LEN(A1))

If this post helps click Yes

 

[Bernard Liengme]

Does this work for you
="xx-xxx-"&RIGHT(A1,4)
best wishes