Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE JE is offline
external usenet poster
 
Posts: 26
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5,651
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
deleting repeated text from a drop down box LTaylor Excel Discussion (Misc queries) 0 March 28th 08 03:04 PM
how do i automatically format repeated text Mel Excel Discussion (Misc queries) 2 February 22nd 07 06:01 PM
Printing text in a repeated cell/row that is longer than repeated Valerie Dyet Excel Discussion (Misc queries) 1 February 13th 06 03:27 AM
Editing Repeated Text Jonny Excel Worksheet Functions 2 November 3rd 05 11:52 AM
repeated text maria Excel Discussion (Misc queries) 2 February 10th 05 10:57 PM


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"