Look Who it Was Random video

Excel Magic Trick # 260: Delete All Invoices w TBO

4,617 views · Published 12 February 2009 · 2:36 · Indexed 22 October 2026

Channel: excelisfun · 2009 · Science & Technology

Watch on YouTube

Download Excel Start File: h https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT252-260.xls
Download Excel Finished File: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/EMT252-260Finished.xls
Full Page With All File Links: https://people.highline.edu/mgirvin/excelisfun.htm

Delete All Invoice Records That Contain an ID with "TBO" using the SEARCH function and Go To Formula Numbers.
SEARCH("TBO","65TBO367123632") would return 3, because the third character starts the text string "TBO" within the larger text string "65TBO367123632".
"Add a new column with this formula (where A2 and all the other cells in column A have the TBO items) and then copy it down:
SEARCH(""TBO"",A2)
This will give you a number when the items contains TBO
Then you can highlight that table, click F5 for Go To; Then click on the Special Button; Then click on the Formulas dialog button; then uncheck all the options except for number; then click OK
Then carefully right-click one of the highlighted cells, point to and then click on Delete; then click the dialog button for Entire Row; Click OK.

More from this channel