Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Credit Card Number
I have a file contain cells having 16 digit credit card number with junk data in between as well. As an example 3486824861529530=0 77681879192405=0 12);3917692181846980 101)980735609630572 95)6040002796620470=0 ^7838705501761190 6114013383107810*/ 8421 7777 9057 6370 9330 64 94 7640 6740 7137482677881720 6982488973900610 What I want to do is as follows 1) Remove all spaces in the cells. 2) After removing the spaces, check in the cell for sixteen consecutive numeric characters which would be the credit card number 3) Populate the credit card number in a separate column. Will you be able to help? -- raj_srini ------------------------------------------------------------------------ raj_srini's Profile: http://www.excelforum.com/member.php...o&userid=32588 View this thread: http://www.excelforum.com/showthread...hreadid=549037 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Entering a number on any sheet one time only | Excel Discussion (Misc queries) | |||
vlookup with more than number to be retrieved | Excel Worksheet Functions | |||
Template to track credit card expenses and expense reports combi | Excel Discussion (Misc queries) | |||
How long will it take to pay off my credit card | Excel Discussion (Misc queries) | |||
How do I do a MOD-10 Credit Card check in Excel? | Excel Worksheet Functions |