How to replace 12 digits only of 16 digit number.

G

Guest

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
 
A

Andy Wiggins

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with Find & Replace 3
This cell contains a date string rep. with only 2 digits for the y 5
How do I get a column with 12 digit numbers to only show the 1st 1 1
Excel 2003: Cell rounds 16 digit numbers- How to advoid rounding? 1
16 digit numbering 8
Edit Replace the third digit only of a number 3
how do i show only the last four digits of a credit card number 5
Help - Any number longer than 12 digits turns to scientific and ro 3

Top