LinkBack URL
About LinkBacks
To count the no of CHAR(10) in a string:
Formula:
=LEN(A2)-LEN(SUBSTITUTE(A2, CHAR(10),""))
Or in code.
NoChar10 = Len(Range("A2"))-Len(Replace(Range("A2"), Chr(10),""))
To count the no of CHAR(10) in a string:
Formula:
=LEN(A2)-LEN(SUBSTITUTE(A2, CHAR(10),""))
Or in code.
NoChar10 = Len(Range("A2"))-Len(Replace(Range("A2"), Chr(10),""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks