LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Hemil
 
Posts: n/a
Default Identification of "<" character at beginning of cell

Hi,

I have an excel column in which I have some values starting with the symbol
"<". say "<x". The other cells have normal values like x. x can be any
number. These values come from a machine.

Now, I want to eliminate all cells/rows in that sheet that have values
starting with the "<" symbol. Is there any way I can do this with the built
in functions/formulae of excel ? Any ideas are appreciated.

Thanks,
Hemil.
 
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
Excel version identification from Visual Basic Raja Ranga Excel Discussion (Misc queries) 6 January 17th 05 08:48 PM


All times are GMT +1. The time now is 09:11 PM.

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

About Us

"It's about Microsoft Excel"