On Sun, 25 Nov 2012 08:55:01 +0000, Jayjones wrote:


Hi guys - trying to replace or substitute data to almost right of
string ie want excel to always count 5 characters from right of cell but
then only replace 4 of the characters with XXXX leaving last character
as it was eg 1234abcde becomes 1234XXXXe or 123456abcdesfgh becomes
123456abcdXXXXh. I have tried right function with replace but can't
manage to leave last digit intact. The replacing text is always XXXX

Also try:

=REPLACE(A1,LEN(A1)-4,4,"xxxx")