Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Count data in cells
If I enter the following into one cell what formula do I use so it recognize
it? 628.9,v14.0,v15.08 I want it to equal 3 |
#2
|
|||
|
|||
One way:
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "DD" wrote in message ... If I enter the following into one cell what formula do I use so it recognize it? 628.9,v14.0,v15.08 I want it to equal 3 |
#3
|
|||
|
|||
It worked...Thanks for your help
"RagDyeR" wrote: One way: =LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "DD" wrote in message ... If I enter the following into one cell what formula do I use so it recognize it? 628.9,v14.0,v15.08 I want it to equal 3 |
#4
|
|||
|
|||
Thanks for the feed-back.
-- Regards, RD -------------------------------------------------------------------- Please keep all correspondence within the Group, so all may benefit! ------------------------------------------------------------------- "dd" wrote in message ... It worked...Thanks for your help "RagDyeR" wrote: One way: =LEN(A1)-LEN(SUBSTITUTE(A1,",",""))+1 -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "DD" wrote in message ... If I enter the following into one cell what formula do I use so it recognize it? 628.9,v14.0,v15.08 I want it to equal 3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
How can I make the graph omit blank cells in the data set? | Charts and Charting in Excel | |||
Glue/Lock cells to external data before refresh | Excel Discussion (Misc queries) | |||
Can I count how many grey-filled cells are in a row ? | Excel Worksheet Functions | |||
How do I copy data (word) into respective cells when the data bei. | New Users to Excel |