I have downloaded my checking account for 2023 into excel. I have slept a lot since I last used excel and don't remember much from back in 2012. Anyway, I want to find all occurrences of debit card numbers in description column (D) and copy the contents of that row to another place in the worksheet so I can total up how our family spent money last year. The values in column D will look like this: "Netflix.com 01-02 netflix.com CA8026DEBIT CARD RECURRING PYMT". where 8026 is one of the card numbers. There may be a function or a formula to do this for me, but I don't know That's why I'm asking you.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
copying rows which contain a 4 digit number
- Thread starter tvhasben
- Start date
I'm using Office 2021. Nearly all the entries follow a similar format where there is a space before the card number such as, "FOOD CITY #701 12-31-22 CHATTANOOGA TN 8142 DEBIT CARD PURCHASE-PIN", or "PAPA JOHN'S #0444 01-14 205-981-2844 TN 8142 DEBIT CARD PURCHASE". Some will have no card number as they were debited by PayPal. Some direct deposits will start with XX like "XXSOC SEC SSA TREAS 310 ASSA *************** ACH CREDIT". Those I can handle with a regular sort and manual copy/paste.
Upvote
0
Similar threads
- Question
- Question
- Solved
- Question
