• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Credit card number trim


New Member
%B4453210200004223^PATEL/SURENDRA ^20042010106600840000000?;4453210200004223=200420100000840?
how to trim only 4453210200004223 in 4453-2102-0000-4223 format. via vba.

Marc L

Excel Ninja
Some directions (as all necessary help is yet within the VBA inner help, a must read) :​
  • use Mid or Split function to extract the desired number
  • use the Format function like you can format a cell with some "-", the same pattern than AliGW used in her post …