Use max() and left() in the same command-CodePudding

Home > Software engineering > Use max() and left() in the same command

Use max() and left() in the same command

Time：07-02

I have data that looks like this and the format of the values is always the same.

entries

12aa
39aa
45ba
18ac
51cc

I want to get the max integer from the column without a helper column.

In this example, the formula would return 51.

CodePudding user response：

If the format is always the same, as you show, with two digits and two alphabet, then simply:

=MAX(--LEFT(myRange,2))