software

How do I replace the last four of an ssn with xxxx? I tried:
Insert gt; function
Old text gt; A1 (or whatever start cell)
Start num gt; 8
Num char gt; 4
New text xxxx

The end result I want is 123-45-xxxx but every time i try to copy the
formula down it alters the successive ssns. Any ideas?how about: =left(a1,7)amp;quot;xxxxquot;

quot;mary squot; wrote:

gt; How do I replace the last four of an ssn with xxxx? I tried:
gt; Insert gt; function
gt; Old text gt; A1 (or whatever start cell)
gt; Start num gt; 8
gt; Num char gt; 4
gt; New text xxxx
gt;
gt; The end result I want is 123-45-xxxx but every time i try to copy the
gt; formula down it alters the successive ssns. Any ideas?
gt;

=LEFT(A1,LEN(A1)-4)amp;quot;xxxxquot;quot;mary squot; wrote:

gt; How do I replace the last four of an ssn with xxxx? I tried:
gt; Insert gt; function
gt; Old text gt; A1 (or whatever start cell)
gt; Start num gt; 8
gt; Num char gt; 4
gt; New text xxxx
gt;
gt; The end result I want is 123-45-xxxx but every time i try to copy the
gt; formula down it alters the successive ssns. Any ideas?
gt;

Is there any way I can lock that formula so that when I copy it down a column
of SSNs the following SSNs don't change?

quot;dlwquot; wrote:

gt; how about: =left(a1,7)amp;quot;xxxxquot;
gt;
gt; quot;mary squot; wrote:
gt;
gt; gt; How do I replace the last four of an ssn with xxxx? I tried:
gt; gt; Insert gt; function
gt; gt; Old text gt; A1 (or whatever start cell)
gt; gt; Start num gt; 8
gt; gt; Num char gt; 4
gt; gt; New text xxxx
gt; gt;
gt; gt; The end result I want is 123-45-xxxx but every time i try to copy the
gt; gt; formula down it alters the successive ssns. Any ideas?
gt; gt;

quot;mary squot; gt; wrote in message
...
gt; quot;dlwquot; wrote:
gt;gt; quot;mary squot; wrote:
gt;gt;
gt;gt; gt; How do I replace the last four of an ssn with xxxx? I tried:
gt;gt; gt; Insert gt; function
gt;gt; gt; Old text gt; A1 (or whatever start cell)
gt;gt; gt; Start num gt; 8
gt;gt; gt; Num char gt; 4
gt;gt; gt; New text xxxx
gt;gt; gt;
gt;gt; gt; The end result I want is 123-45-xxxx but every time i try to copy the
gt;gt; gt; formula down it alters the successive ssns. Any ideas?

gt;gt; how about: =left(a1,7)amp;quot;xxxxquot;

gt; Is there any way I can lock that formula so that when I copy it down a
gt; column
gt; of SSNs the following SSNs don't change?

You're not copying the formula down column A, are you? If your existing
SSNs are in column A, put your formula in column B (or any convenient empty
column). If, when you've done that, you want to replace the old SSNs with
the new ones, you can cut, then paste special/ values.
--
David Biddulph
Yeah. I was creating the formula and copying it down the same column. They
all work once I enter them in a new blank column and copy down. Thanks
everyone for your help!

quot;David Biddulphquot; wrote:

gt; quot;mary squot; gt; wrote in message
gt; ...
gt; gt; quot;dlwquot; wrote:
gt; gt;gt; quot;mary squot; wrote:
gt; gt;gt;
gt; gt;gt; gt; How do I replace the last four of an ssn with xxxx? I tried:
gt; gt;gt; gt; Insert gt; function
gt; gt;gt; gt; Old text gt; A1 (or whatever start cell)
gt; gt;gt; gt; Start num gt; 8
gt; gt;gt; gt; Num char gt; 4
gt; gt;gt; gt; New text xxxx
gt; gt;gt; gt;
gt; gt;gt; gt; The end result I want is 123-45-xxxx but every time i try to copy the
gt; gt;gt; gt; formula down it alters the successive ssns. Any ideas?
gt;
gt; gt;gt; how about: =left(a1,7)amp;quot;xxxxquot;
gt;
gt; gt; Is there any way I can lock that formula so that when I copy it down a
gt; gt; column
gt; gt; of SSNs the following SSNs don't change?
gt;
gt; You're not copying the formula down column A, are you? If your existing
gt; SSNs are in column A, put your formula in column B (or any convenient empty
gt; column). If, when you've done that, you want to replace the old SSNs with
gt; the new ones, you can cut, then paste special/ values.
gt; --
gt; David Biddulph
gt;
gt;
gt;