| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro for finding number of times a word repeats in a cell
Hi,
I am a very amateur excel user. Can you help me with a macro to find a particular word/phrase from the spreadsheet and give an output on the number of times a word/phrase is repeated in a different cell E.g If Cell B5 has the word "This spreadsheet contains information on basic excel topics and advanced excel topics". A macro should find that the phrase "excel topics" had been repeated twice in cell B5 of the spreadsheet. This number should be printed in cell C5. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting number of times a specific word appears in a single cell | Excel Discussion (Misc queries) | |||
| Finding the number of times a word is used in a range of cells | Excel Worksheet Functions | |||
| Finding Minimum but if same number repeats in the range, then find | Excel Discussion (Misc queries) | |||
| finding a number and the number of times it occurs | Excel Discussion (Misc queries) | |||
| How can I count the number of times a letter repeats in a string? | Excel Worksheet Functions | |||
Threaded Mode
