Select the data you want to view. Then press Export -> Select Custom -> Output (select View output as text). Scroll to the bottom and uncheck Dump Binary columns as hexidecimal, and then press the Go button.
Thanks @Lawrence, copied table and then dropped all other fields and was able to then view all as you described. would never of unchecked that tick at the bottom in phpmyadmin (as i use HeidiSQL, and it doesn't seem possible )