change last name

[manceI]

is there a way to change the last 4 letters of a last name

For example if "A1" has the name Janet Robinson can we make "b1" have Janet Robixxxx ? Thus changing the last 4 letters of the last name to xxxx

Thanks

[berlan]

Try

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