Hi Everyone!
I have attached an excel sheet where column A contains space sperated text values(Which are english names). Now I want the longest text value out of each cell into column B for each corresponding cell in column A.
If we rephrase the above requirement, we are just extracting the longest text string out of the each row in column A. So cell A1 CONTAINS value "Sun Moon Sky" then the corresponding value in column B1 should be "Moon" as it have 4 characters which is the highest among all 3 words.
Please check the attached file. Thanks
Bookmarks