Two words of 3 letters twice

[makinmomb]

I came across this word called

LOGLOGS

I need macro to scan dictionary and place such words at c1 downwards

LOGIC , 3 letter word twice in the word , this means LOG was twice in the word

If it pours correctly it will pull BULBULS others i forgot

Find attached

[kvsrinivasamurthy]

VBA code:

Please Login or Register  to view this content.

[HansDouwe]

Here are solutions with a formula:

Excel 2007 and newer:

Please insert an empty row at the top and try in C2 and copy down (confirm the formula with Ctrl+Shift+Enter; response time after copy down about 20 seconds):

Please Login or Register  to view this content.

Excel 2021 or 365:

Please try in D2 (no copy down needed; response time within 1 second):

Please Login or Register  to view this content.

[JohnTopley]

Another ("borrowed" some of KVS code

Please Login or Register  to view this content.

[JEC.]

A solution with Regular Expression

Please Login or Register  to view this content.

[makinmomb]

Nice one hansdouwe that too without macro

[makinmomb]

JT yours is correct through same results against formula , thank you

[makinmomb]

JEC must be correct too , thank you all

[makinmomb]

KV nice if JT borrowed some codes from you

[HansDouwe]

You are Welcome! Thanks for the rep. with kindly rep. comment . Glad to have helped with a formula. .