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: 173
Default Count first and last characters

Dear Expert,

I have got a file which have a system generated field below. (15 rows)
First character must be either "T", "F", "U".
Last character must be either "D", "S", "U".

How to write a function that can calculate how much "T" or "F" for the first
character under the series.
How to write a function that can calculate how much "D" or "S" for the last
character under the series.

TLD
TLD
FLD
TLD
TND
UU
TNS
TND
TNS
TMD
TMD
TLS
TMS
TLD
TMD

 
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 do I count the Characters in a cell Woozy Excel Discussion (Misc queries) 5 January 8th 09 08:26 AM
Count Characters in A Cell Daren Excel Discussion (Misc queries) 4 October 1st 08 02:34 PM
count characters Rich[_2_] Excel Discussion (Misc queries) 2 August 23rd 08 09:14 PM
count special characters Gaurav[_2_] Excel Worksheet Functions 3 April 17th 08 08:09 PM
Count Characters sjs Excel Worksheet Functions 6 December 9th 05 08:40 PM


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