View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TomL TomL is offline
external usenet poster
 
Posts: 1
Default 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