Formula to take highest value

I need a formula/ way so that highest value can be extracted from the following columns

Column1 Column2 Column3 Column4 Column5

highest numeric value should SB,111,123,145,158 AC,101,146,178,112 XB,107,111,109 CD,99,47,189,157
come in this column from Columns
2,3,4,5

Please advise...
Thanx & rgds,
Shubh