**Question description:**

*This user has given permission to use the problem statement for this
blog.*

I want to find cells in which a word is duplicated. For example if A1 contains "house fish car house" it should be highlighted because "house" is double. The words can be in any position inside the cell so it could be "house house fish car" or "car house fish house"

Solved by Z. B. in 19 mins

This is the chat thread from the real Excelchat help session. It contains no private user
information.

Excelchat Expert
06/04/2018 - 11:46

Hi

User
06/04/2018 - 11:47

Hi

Excelchat Expert
06/04/2018 - 11:47

Welcome to Got it Pro

User
06/04/2018 - 11:47

Thanks

Excelchat Expert
06/04/2018 - 11:47

I understand your requirement.

Excelchat Expert
06/04/2018 - 11:48

do you have any excel sheet?

User
06/04/2018 - 11:48

no but i can paste some rows in

Excelchat Expert
06/04/2018 - 11:48

ok. Please create

User
06/04/2018 - 11:49

unfortunately i cant format the cells

User
06/04/2018 - 11:49

it should be formatted as text

Excelchat Expert
06/04/2018 - 11:49

No problem

Excelchat Expert
06/04/2018 - 11:50

Can you paste again

Excelchat Expert
06/04/2018 - 11:51

Do paste special Values

Excelchat Expert
06/04/2018 - 11:52

Thank you

Excelchat Expert
06/04/2018 - 11:52

No tell me.

Excelchat Expert
06/04/2018 - 11:52

*Now tell me.

User
06/04/2018 - 11:52

so if in one of thes cells a word is double, i need it to be highlighted

User
06/04/2018 - 11:53

im searching an example

Excelchat Expert
06/04/2018 - 11:53

Any example cell.

User
06/04/2018 - 11:53

743

User
06/04/2018 - 11:53

the word "Aarau is double

Excelchat Expert
06/04/2018 - 11:53

Aarau?

Excelchat Expert
06/04/2018 - 11:53

Oh ok.

Excelchat Expert
06/04/2018 - 11:54

Do you want to search specific test in all the rows.

Excelchat Expert
06/04/2018 - 11:54

or any words repeated two time you would like to highlight

User
06/04/2018 - 11:54

the second, any word

User
06/04/2018 - 11:54

if thats not possible we can also do specific test

User
06/04/2018 - 11:54

but i'd rather have any word

Excelchat Expert
06/04/2018 - 11:55

Specific Test is possible

User
06/04/2018 - 11:55

okay

Excelchat Expert
06/04/2018 - 11:55

One minute

Excelchat Expert
06/04/2018 - 12:00

Please Check this

[Uploaded an Excel file]

Excelchat Expert
06/04/2018 - 12:01

Are you there?

User
06/04/2018 - 12:02

yes

Excelchat Expert
06/04/2018 - 12:02

Please Check example I am searching word Aarau

Excelchat Expert
06/04/2018 - 12:02

I have displayed the result in Column E

User
06/04/2018 - 12:03

ah i see

User
06/04/2018 - 12:03

its case sensitive right?

Excelchat Expert
06/04/2018 - 12:03

Yes. Do you want Ignore Case Sensitive?

User
06/04/2018 - 12:03

if possible

Excelchat Expert
06/04/2018 - 12:04

ok . 2 minutes

Excelchat Expert
06/04/2018 - 12:04

Please extend the time

User
06/04/2018 - 12:04

where?

Excelchat Expert
06/04/2018 - 12:05

No need fixed

[Uploaded an Excel file]

Excelchat Expert
06/04/2018 - 12:05

Request you to provide valuable feedback and session going to end within 1 minute

Excelchat Expert
06/04/2018 - 12:05

It will ignore case sensitive.

User
06/04/2018 - 12:05

I will

User
06/04/2018 - 12:05

thanks!

Excelchat Expert
06/04/2018 - 12:06

welcome :)

Excelchat Expert
06/04/2018 - 12:06

Please connect with us again If you need any support.

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user
information.*