Staring part of infornation in a columns

Redseeing · External Since: Sep 24, 2009 Posts: 2

Hello, this is my problem. I have to send information with credit card
information. I need to star (****) out the middle 8 digits for security
reasons. I would do this manually but there are over 10, 000 card numbers.
Any help would be grateful.

Dave Peterson · External Since: Jul 08, 2005 Posts: 16046

You could use a helper column with a formula like:

=left(a1,4)&rept("*", Cool

&right(a1,4)

You may have to adjust the lengths to match the format of your data (depending
on the length of those credit card strings).

Then drag this formula down the column as far as you need.

Convert the formulas to values (edit|copy, edit|paste special|values)

And delete the original column of credit card numbers.

Make sure you delete that column--don't just hide it. Excel's security won't
stop anyone from looking at a hidden column.

Redseeing wrote:
>
> Hello, this is my problem. I have to send information with credit card
> information. I need to star (****) out the middle 8 digits for security
> reasons. I would do this manually but there are over 10, 000 card numbers.
> Any help would be grateful.

--

Dave Peterson

Redseeing · External Since: Sep 24, 2009 Posts: 2

Sorry for more questions but how would I make =LEFT(A1,4)&

REPT("*", Cool

&RIGHT(A1,4)

Copy everything from A1:A10 to C1:C10?

"Dave Peterson" wrote:

> You could use a helper column with a formula like:
>
> =left(a1,4)&rept("*", Cool

&right(a1,4)
>
> You may have to adjust the lengths to match the format of your data (depending
> on the length of those credit card strings).
>
> Then drag this formula down the column as far as you need.
>
> Convert the formulas to values (edit|copy, edit|paste special|values)
>
> And delete the original column of credit card numbers.
>
> Make sure you delete that column--don't just hide it. Excel's security won't
> stop anyone from looking at a hidden column.
>
>
>
> Redseeing wrote:
> >
> > Hello, this is my problem. I have to send information with credit card
> > information. I need to star (****) out the middle 8 digits for security
> > reasons. I would do this manually but there are over 10, 000 card numbers.
> > Any help would be grateful.
>
> --
>
> Dave Peterson
>

Gord Dibben · External Since: Feb 23, 2004 Posts: 9178

Paste the formula Dave posted into C1

Copy the formula down to C10 by dragging the fill handle of C1

Gord Dibben MS Excel MVP

On Thu, 24 Sep 2009 09:21:03 -0700, Redseeing
<Redseeing.TakeThisOut@discussions.microsoft.com> wrote:

>Sorry for more questions but how would I make =LEFT(A1,4)&
>
>REPT("*", Cool

&RIGHT(A1,4)
>
>Copy everything from A1:A10 to C1:C10?
>
>"Dave Peterson" wrote:
>
>> You could use a helper column with a formula like:
>>
>> =left(a1,4)&rept("*", Cool

&right(a1,4)
>>
>> You may have to adjust the lengths to match the format of your data (depending
>> on the length of those credit card strings).
>>
>> Then drag this formula down the column as far as you need.
>>
>> Convert the formulas to values (edit|copy, edit|paste special|values)
>>
>> And delete the original column of credit card numbers.
>>
>> Make sure you delete that column--don't just hide it. Excel's security won't
>> stop anyone from looking at a hidden column.
>>
>>
>>
>> Redseeing wrote:
>> >
>> > Hello, this is my problem. I have to send information with credit card
>> > information. I need to star (****) out the middle 8 digits for security
>> > reasons. I would do this manually but there are over 10, 000 card numbers.
>> > Any help would be grateful.
>>
>> --
>>
>> Dave Peterson
>>