Formula Query

[davids]

I was wondering if there is a formula to replace the first four digits of any
given sequence of numbers ie 1234567 needs to be replaced with xxxx567.the
length of the numbers are varied ie the number could also be 12345 in which
case it needs to be replaced with xxxx5.

Thanks

 

[David Biddulph]

I was wondering if there is a formula to replace the first four digits of
any
given sequence of numbers ie 1234567 needs to be replaced with xxxx567.the
length of the numbers are varied ie the number could also be 12345 in
which
case it needs to be replaced with xxxx5.

="xxxx"&RIGHT(A1,LEN(A1)-4)