wilg19
04-10-2017, 03:59 PM
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
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