find text string in column & count occurences

Microsoft Excel 2010 - windows
October 4, 2010 at 07:59:27
Specs: Windows 7
Hello please help!
In my worksheet I have a column where each cell contains text (lines from a twitter feed). I now need to search this column to see how many times certain strings of text appear in the cells. I can do a simple find using =COUNTIF(tabname!B3:B2734,"*" & A18 & "*") where the text is in column B on tab tabname and the string to find is stored in column A on the tab the formula is on.

This will find the string but is not case sensitive which I really need - any help is highly appreciated, thanks!

See More: find text string in column & count occurences

Report •

October 4, 2010 at 08:47:26
Try either one of these:




Report •
Related Solutions

Ask Question