Is there a function that will give me the count of a certain character (such as a '.') in a cell?
For example:
in cell A1 is - 1001.123.456
Answer would be 2.
Is there a function that will give me the count of a certain character (such as a '.') in a cell?
For example:
in cell A1 is - 1001.123.456
Answer would be 2.
Last edited by Mick S; 04-09-2011 at 03:12 PM.
=len(a1) - len(substitute(a1, ".", ""))
Entia non sunt multiplicanda sine necessitate
That worked. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks