ExcelBanter - how to find records that start with the same word in a worksheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how to find records that start with the same word in a worksheet (https://www.excelbanter.com/excel-discussion-misc-queries/445649-how-find-records-start-same-word-worksheet.html)

sumesh56

how to find records that start with the same word in a worksheet

i have a worksheet in which there are records start with the same word--- http://.

i want to delete those records that start with the word http://.

how can i accomplish that?

Don Guillett[_2_]

how to find records that start with the same word in a worksheet

On Monday, April 2, 2012 8:27:54 PM UTC-5, sumesh56 wrote:
i have a worksheet in which there are records start with the same
word--- http://.

i want to delete those records that start with the word http://.

how can i accomplish that?

--
sumesh56

why not just use \
datafilterautofiltercustom filter column for "begins with"

All times are GMT +1. The time now is 12:58 PM.