Search for the highest number in a column between two brackets [ ]

[Mixphonics]

Hello fellow Excel users,

I am hoping that someone might know of a way to search for the highest number in a column between two brackets?

I have a column that has different types of text.

Example:
J-100
J-236
[1]
[2]
J-500
[3]

is there a way to search for the highest value of between the bracketed numbers?

I've searched around on the forum and couldn't find the answer, any help would be appreciated.

Thank you.

 

[Aladin Akyurek]

Thanks Rick, I was pressing CTRL+SHIFT+ENTER when the cell was selected not in the formula box and that was my problem.

It works now.

Thank you Aladin for the formula!

You are welcome. Also, Rick thanks...