Need Excel Formula to find the max number of characters of 1 word in a cell
Budget: $14 – $30 NZD
I have a small project. I need a formula in excel to find the max number of characters of 1 word or phrase in a cell
For example this below is in 1 cell
"Centrifugal Automatic Clutch 10/11/12/13/14/18Tooth"
Therefore the max character length should return 22 because the longest word/phrase in the cell is "10/11/12/13/14/18Tooth" which has 22 characters.
For example this below is in 1 cell
"Centrifugal Automatic Clutch 10/11/12/13/14/18Tooth"
Therefore the max character length should return 22 because the longest word/phrase in the cell is "10/11/12/13/14/18Tooth" which has 22 characters.