copying rows which contain a 4 digit number

[tvhasben]

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.

 

[Cubist]

Which version of Excel are you using? You should update your Account Details.
Can you provide more samples? Is the format consistent?

 

[tvhasben]

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.

 

[Cubist]

Maybe this.

Book1
	A	B
1	Netflix.com 01-02 netflix.com CA 8026 debit CARD RECURRING PYMT	8026
2	FOOD CITY #701 12-31-22 CHATTANOOGA TN 8142 DEBIT CARD PURCHASE-PIN	8142
3	PAPA JOHN'S #0444 01-14 205-981-2844 TN 8142 DEBIT CARD PURCHASE	8142
Sheet8

Cell Formulas
Range	Formula
B1:B3	B1	=MID(A1,SEARCH("DEBIT",A1)-5,4)