Thanks for the help Arvilaanemets!

Is there any other way to directly convert the code in to the particular cell?

I have the excel data which already more columns to scroll and also hyphenated values are cut-off (for ex., J24-26 becomes J24).

Please advise