| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting Elements in a String
I have strings like these:
AB;CD;EF;GH;IJ Is there an easy way to count the number of elements in the string. In this case the count would be 5. Thank you in advance. |
|
#2
|
|||
|
|||
|
Hi
=LEN(A1)-LEN(SUBSTITUTE(A1,";";""))+1 -- Regards Frank Kabel Frankfurt, Germany carl wrote: I have strings like these: AB;CD;EF;GH;IJ Is there an easy way to count the number of elements in the string. In this case the count would be 5. Thank you in advance. |
|
#3
|
|||
|
|||
|
One way:
=LEN(A1)-LEN(SUBSTITUTE(A1,";",""))+1 -- Best Regards Leo Heuser Followup to newsgroup only please. "carl" skrev i en meddelelse ... I have strings like these: AB;CD;EF;GH;IJ Is there an easy way to count the number of elements in the string. In this case the count would be 5. Thank you in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extract hyperlink string from excel cell | Links and Linking in Excel | |||
| Counting every unique text string in a column | Excel Worksheet Functions | |||
| Delemited string | Excel Worksheet Functions | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
| Add a string to a cell | Excel Worksheet Functions | |||
Linear Mode
