I need to count the number of numric values in a cell that could be a single value or many values that are semi-colon delimited and there are about 8k rows like this in one column. All the items are numeric values that range from 1 digit to 9 digits. Any ideas on how to count them?
Thanks,
Paul
So in a cell where the values are semi-colon delimited the number of values will be equal to the number of delimiters (semi-colons) plus one? Or is there a final semi-colon delimiter (after the final value) in delimited strings?
Regards
I take it is number of semicolons + 1. Try this:
=LEN(SUBSTITUTE(A1,";",";;"))-LEN(A1)+1
Pauley
--------
If I helped with your issue, I'd appreciate a rep bump (hit the '*' icon to the bottom left of this post).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks