How to replace 12 digits only of 16 digit number.
 

I need to replace the first twelve digits without effecting the last four of
an account number. Hoping may use the "Find and replace" command without have
to replace manually.

The repetitive task is as follows in Excel Spreadsheet:

Replace 2305-1324-5543-2144 numbers with xxxx-xxxx-xxxx-2144

How to replace 12 digits only of 16 digit number.
 

Using Edit Replace
In "Find what?" put: ????-????-????-
In "Replace with" put: xxxx-xxxx-xxxx-

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"TomL" wrote in message
...
I need to replace the first twelve digits without effecting the last four
of
an account number. Hoping may use the "Find and replace" command without
have
to replace manually.

The repetitive task is as follows in Excel Spreadsheet:

Replace 2305-1324-5543-2144 numbers with xxxx-xxxx-xxxx-2144