LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How to recognise a small letter as being different to a capital le

Looking to use 'h' in an attendance record to denote 1/2 day's holiday taken,
then the 'H' denotes a whole day

How would this be possible? Can't see how to get the function to recognise
'h' as being different to 'H' in order to use a function
 
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
How to change cases from small to capital in all cells? Khoshravan Setting up and Configuration of Excel 3 September 18th 06 09:26 PM
New Validation option to format 1st letter as Capital letter Jeff Excel Discussion (Misc queries) 5 July 13th 06 05:11 AM
Default Capital letter for 1st letter of a word Jeff Excel Discussion (Misc queries) 6 July 10th 06 08:36 AM
Countif a small or capital letter hodkd Excel Worksheet Functions 5 October 11th 05 02:55 AM
Sentence with first letter in Capital, rest all in small. Shrikant Excel Discussion (Misc queries) 3 September 1st 05 11:23 AM


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