Stripping certain data from left side of a string

[NWA John]

Need help to strip off the Date & Time from the start of certain cells. If Date & Time are not in the string just ignore it & go to the next cell down. Thanks


01/01 02:04 discovery+ 0123456789 TN CKCD DEBIT 6507


01/03 12:21 WAL-MART Wal-Mar FARMINGTON POS DEBIT 6507


01/03 12:05 COLLIER DRUG FAR FARMINGTON POS DEBIT 6507


AC-BENEFIT PAYMENTS-DEPOSIT


AC-OZARKS ELECTRIC -PPDDRAFT


AC-OZARKS ELECTRIC -PPDDRAFT


AC-CITY FAYETTEVILL-UTILITYPMT


AC-USAA CHK-INTRNT -TRANSFER


01/05 02:23 ADOBE *PRODUCTS 4085366000 CA CKCD DEBIT 8040


01/06 11:42 LOWE'S #1806 FAYETTEVILLE POS DEBIT 8040

[georgiboy]

If the times/ dates are always in that format you can use the find/ replace dialogue:

Click CTRL + F
Click on the Replace tab
Put this into the find what box without the quotes: "??/?? ??:?? "
Leave the replace with box blank
Click the Replace All button

[NWA John]

If the times/ dates are always in that format you can use the find/ replace dialogue:

Click CTRL + F
Click on the Replace tab
Put this into the find what box without the quotes: "??/?? ??:?? "
Leave the replace with box blank
Click the Replace All button

[NWA John]

Probably simple to you, but BRILLIANT to me...Thanks so much!