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: 355
Default Counting specific letters in a cell

How do I count the number of specific letters in a given cell? For example
if a cell has the words "Have a nice day!" I would only want to count only
the letter "a." Is there some sort of IF-LEN-combo function? Help.
 
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
counting letters in excel cell kas Excel Discussion (Misc queries) 1 May 15th 08 06:37 PM
Can I recognize the specific letters in a cell using formulas? Stevo Excel Worksheet Functions 3 March 26th 08 12:41 PM
Counting letters in a cell Learning Excel Excel Discussion (Misc queries) 6 March 15th 08 08:11 PM
Counting the number of letters in a cell beefycj5 Excel Discussion (Misc queries) 2 June 1st 05 08:28 PM
Counting specific text in a cell Steve Excel Worksheet Functions 7 January 26th 05 05:51 PM


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