Finding longest word in a cell

Just for fun.
I'm trying to find longest word in a cell. For example:

long interspersed element

The result should be "interspersed"

Good evening ContaminatedWitExcel

Originally Posted by ContaminatedWitExcel

I'm trying to find longest word in a cell.

There's quite a discussion about that very subject here - namely the pros and cons of using a UDF vs a native formula. Along with a few solutions to the problem.

HTH

DominicB