| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count no. of commas (,) in a string in a cell
How can we count number of commas (,) appearing several times in a text
string in one cell. Is there any function which can be pasted in cell (B1) to count no. of commas in cell (A1). pl help hsg |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count no. of commas (,) in a string in a cell
Try this formula...
=LEN(A1)-LEN(SUBSTITUTE(A1,",","")) -- Rick (MVP - Excel) "hsg" wrote in message ... How can we count number of commas (,) appearing several times in a text string in one cell. Is there any function which can be pasted in cell (B1) to count no. of commas in cell (A1). pl help hsg |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count no. of commas (,) in a string in a cell
=LEN(A1)-LEN(SUBSTITUTE(A1,",",""))
best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "hsg" wrote in message ... How can we count number of commas (,) appearing several times in a text string in one cell. Is there any function which can be pasted in cell (B1) to count no. of commas in cell (A1). pl help hsg |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count no. of commas (,) in a string in a cell
This is already answered. My query yesterday showed error in sending, so i
sent it again today, but later I found that my both querries were there online and were asnwered as well. Thanks for help "hsg" wrote: How can we count number of commas (,) appearing several times in a text string in one cell. Is there any function which can be pasted in cell (B1) to count no. of commas in cell (A1). pl help hsg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to count commas in a cell? | Excel Worksheet Functions | |||
| Count the number of Commas found in cell A2 | Excel Worksheet Functions | |||
| formula to count commas | Excel Discussion (Misc queries) | |||
| Count values between commas | Excel Discussion (Misc queries) | |||
| Count Commas in Cells | Excel Discussion (Misc queries) | |||
Linear Mode
