Hello,
I would like to write an UDF that counts how many times a word is repeated in a cell. see the picure enclosed.
Hello,
I would like to write an UDF that counts how many times a word is repeated in a cell. see the picure enclosed.
Why not use a formula such as
VBA Noob=SUMPRODUCT((LEN(A1)-LEN(SUBSTITUTE(UPPER(A1),"ASD","")))/LEN("ASD"))
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks