| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count the number of Commas found in cell A2
Is there a way to count the number commas (,) in a cell?? I am doing
a text to column by Commas (,) then doing a Countif on the data to get my number... Is there a was to count with doing the text to column???? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count the number of Commas found in cell A2
Here's one way to count
the number of commas in a cell: =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "B~O~B" wrote in message ... Is there a way to count the number commas (,) in a cell?? I am doing a text to column by Commas (,) then doing a Countif on the data to get my number... Is there a was to count with doing the text to column???? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count the number of Commas found in cell A2
On Apr 2, 11:59 am, "Ron Coderre"
wrote: Here's one way to count the number of commas in a cell: =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "B~O~B" wrote in message ... Is there a way to count the number commas (,) in a cell?? I am doing a text to column by Commas (,) then doing a Countif on the data to get my number... Is there a was to count with doing the text to column????- Hide quoted text - - Show quoted text - Work for me.... Thanks you very much... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Count the number of Commas found in cell A2
You're welcome.....I'm glad I could help.
Regards, Ron Microsoft MVP (Excel) "B~O~B" wrote in message ... On Apr 2, 11:59 am, "Ron Coderre" wrote: Here's one way to count the number of commas in a cell: =LEN(A1)-LEN(SUBSTITUTE(A1,",","")) Does that help? -------------------------- Regards, Ron Microsoft MVP (Excel) (XL2003, Win XP) "B~O~B" wrote in message ... Is there a way to count the number commas (,) in a cell?? I am doing a text to column by Commas (,) then doing a Countif on the data to get my number... Is there a was to count with doing the text to column????- Hide quoted text - - Show quoted text - Work for me.... Thanks you very much... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to count commas | Excel Discussion (Misc queries) | |||
| Count values between commas | Excel Discussion (Misc queries) | |||
| Count Commas in Cells | Excel Discussion (Misc queries) | |||
| Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
| how to display the count of lines found by autofilter? | Excel Discussion (Misc queries) | |||
Linear Mode
