Counting text in a range is easy. For example, if you would like count how many times “text” is in a specified range (named data), you can write something like this: =COUNTIF(data,”*text*”) This formula will give you the count of all the cells where Excel found “text” at any place. But let’s say you want […]
Continue readingOh, man, I can’t tell how useful that concatenate function is. One repetitive use I found is to create OR/AND conditions for Access queries. I copy and paste the field values of a column from Access, do some filtering and my conditions are ready. Then I use this concat2 function to create a string to […]
Continue readingI found this on microsoft’s website. I didn’t know that I can use MID function on the LHS and converting string to ASCII will speed up the process. Cool!! “The following points provide suggestions for ways to enhance the performance of string operations: Minimize concatenation operations when you can. You can use the Mid function […]
Continue readingDefinition of palindrome as given in Answers.com pal?in?drome (p?l’?n-dr?m’) n. A word, phrase, verse, or sentence that reads the same backward or forward. For example: A man, a plan, a canal, Panama! Function IsPalindrome(sInput As String) As Boolean If sInput = StrReverse(sInput) Then IsPalindrome = True Else IsPalindrome = False End If End Function
Continue reading