Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Senior Member
 
Posts: 118
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,522
Default 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"
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find and boldface a single word everywhere in a worksheet Artis Tiedemann Excel Worksheet Functions 4 November 3rd 08 03:21 PM
Start MS Word? dimm Excel Programming 4 March 16th 08 10:05 PM
I need a criteria expression to not include records that start wit Steve A Excel Worksheet Functions 2 August 16th 06 07:57 PM
Exclude records that start with * Steve A Excel Worksheet Functions 3 August 16th 06 05:51 PM
How to start every word in a cell uppercase? terrya64 Excel Discussion (Misc queries) 1 July 25th 05 02:03 AM


All times are GMT +1. The time now is 02:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"