convert alpha to numeric

[wilg19]

Hi, I have the following that I need to convert from Alpha to numeric..



LANE 1


D+I:F+B
D+I
F+B



I'm using =split(J7,":",true) to split the D+:F+B into the following two columns

what I need is to convert the letters now to numeric like



LANE 1


D+I:F+B
4+9
6+2



I found this formula that converts to numeric =COLUMN(INDIRECT(I27&1)) but I can seem to incorporate into my split..

any help much appreciated

[wilg19]

I was able to solve...

=COLUMN(INDIRECT((Mid(J7,1,1))&1))&"+"&COLUMN(INDIRECT((Mid(J7,3,1))&1))

This did what I needed.