Credit card number trim

[Surendra100]

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

 

[AliGW]

Here's a formula solution:

=TEXT(MID(A1,FIND(";",A1)+1,16),"####-####-####-####")

 

[bosco_yip]

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

The OP wish the solution via VBA, so this thread is moved to VBA Forum.

Regards

 

[Marc L]

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 …

 

[Surendra100]

Here's a formula solution:

=TEXT(MID(A1,FIND(";",A1)+1,16),"####-####-####-####")

Thank you.