ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Find repeated text in a text document in Excel (https://www.excelbanter.com/excel-worksheet-functions/190422-find-repeated-text-text-document-excel.html)

JE

Find repeated text in a text document in Excel
 
Hi:

I pasted several paragraphs of a text in Excel and I would like a simple way
for it to highlight all of the repeated words. Excel 2007.

Thanks

Ron Rosenfeld

Find repeated text in a text document in Excel
 
On Sat, 7 Jun 2008 13:03:00 -0700, JE wrote:

Hi:

I pasted several paragraphs of a text in Excel and I would like a simple way
for it to highlight all of the repeated words. Excel 2007.

Thanks


Post an example, and exactly what you want highlighted.

How close together must the repeated words be?
What if there are multiple repeated words?

For example, in the above three lines, the words "repeated" and "words" occur
more than once.
--ron

Ron Rosenfeld

Find repeated text in a text document in Excel
 
On Sat, 7 Jun 2008 13:03:00 -0700, JE wrote:

Hi:

I pasted several paragraphs of a text in Excel and I would like a simple way
for it to highlight all of the repeated words. Excel 2007.

Thanks


One other question -- is the text all in one cell, or is it in multiple cells?
--ron


All times are GMT +1. The time now is 11:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com