LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel 2003 Identify a single character in column

I have a list of student usernames for our website. Generally the default is
firstname.lastname but some students have firstname1.lastname. I am trying to
identify all the students with firstname1.lastname and I would like to run a
conditional format that identifies all cells that contain the number 1 (even
if it is part of a word, in this case name.

Thanks
 
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
Formula to identify character formatting (bold, italic, etc) alphaorionis Excel Worksheet Functions 3 July 1st 07 11:19 PM
How can I adjust column width of a single cell within Excel 2003? biotekengineer Excel Discussion (Misc queries) 2 October 5th 06 10:58 AM
How do I perfom a character count in a single cell in Excel? RonNette72791 New Users to Excel 1 August 11th 06 05:49 PM
Duplicate Text within single cell. How to identify & split TeRex82 Excel Worksheet Functions 4 June 21st 06 08:30 AM
identify data in a cell that has a number as the second character Brian Excel Worksheet Functions 1 December 12th 04 03:23 PM


All times are GMT +1. The time now is 01:22 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"