I have a formula =LEN(B4)-LEN(SUBSTITUTE(B4,"2","")) and I want to enter the answers down a different column all the way down (say column E,F,G,H,I etc. It works in one cell only.
I have a formula =LEN(B4)-LEN(SUBSTITUTE(B4,"2","")) and I want to enter the answers down a different column all the way down (say column E,F,G,H,I etc. It works in one cell only.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks