[Solved] Which cell has the most characters? formula?

[Hagar Delest]

Hello, I have a question, I have 5 columns, and in each row of the column there is a given name as in the attachment.
What to do that in column G, or some other one next, fomula showed me which cell has the most characters, or most character ">" and showed or indexed it?
So something like: indicate which cell has the most characters, or character ">" and show it.

[Lupp]

There is a fundamental problem with your question: The ONE cell "with the most characters" will simply not exist if there are more than one cells containing the same maximum number of characters.
Acceptably simple means (formulas based on standard functions) will only return the first cell containing the maximum found. There may be more to the right (if matched in a row) or to the bottom (if matched in a column).
If more complexity is accepted, you still need to consider that a cell only can return ONE result. Returning more than one match in a cell would require to create something like a list in text form. AOO does not provide a standard function for this purpose.
Also see attachment. Errors and the "second-match-issue" are marked there by coloring.

[dawidek990]

ok, is fine, formula can show me first finded row.
But now how i can index it? formuła show me d4 but i need cell content.

[keme]

... how i can index it? ...

Use the INDEX() function

[Zizi64]

formuła show me d4 but i need cell content.

Try the function INDIRECT().

[Lupp]

Omitting the ADDRESS() function and instead passing the MATCH() result to the INDEX() function as the column index should be rather efficient.
I only used ADDRESS() in the preliminary solution to ease the comparison with what the OQer already had entered by hand.

[dawidek990]

INDIRECT() is the best and most simple function ;]
is working, thank you very much ;]