Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Letter Counting Function
I know Excel has a function for counting letter/characters in a cell, but I don't want it to count spaces. Any way to accomplish this? And forgive me if topic exists somewhere on this forum. I wanted to do a search first, but clicking on "search" does nothing. Thanks! Robert -- bctrophy ------------------------------------------------------------------------ bctrophy's Profile: http://www.excelforum.com/member.php...o&userid=29830 View this thread: http://www.excelforum.com/showthread...hreadid=495350 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Letter Counting Function
Try this... For text in Cell A1 B1: =LEN(SUBSTITUTE(A1," ","")) It replaces spaces with nothing, then counts the length. Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=495350 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Letter Counting Function
Ron, That did it. Works like a charm. Much appreciated!!!! -- bctrophy ------------------------------------------------------------------------ bctrophy's Profile: http://www.excelforum.com/member.php...o&userid=29830 View this thread: http://www.excelforum.com/showthread...hreadid=495350 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Varying left criteria based on 1st Letter....If Function? | Excel Discussion (Misc queries) | |||
Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |