From columns A:Y I have fields filled in a letter (ie, "A") or letter and number (ie, Y1) or up to three letters with or without a single numeric digit (ie, "ABC" or "ABC1")
I have named each cell and given them a description of what they represent. These letters and numbers are used in tax formulas that I'm not able to change. So I have to compromise here a bit.
I cannot reference them by "Y1" in the formula (obstacle: Y1 could actually be located in cell Y2 and "Y" is in cell Y1) I want to adjust the formula on my end. I want to replace "A" with "Alpha", "Y" with "Yankee" and so on (NATO phonetics with some personal adjustments).
My problem is, when I change cells in column E to include "Echo", and if its a combo of "YE1" for example, then I end up with "YankeEcho1".
I'm going to provide the phonetics I will be using below as I would imagine someone would ask for them if I don't
A,Alpha
A1,Alpha1
B,Beta
B1,Beta1
C,Charlie
D,Delta
D1,Delta1
E,Echo
EI,EchoIndigo
F,Foxtrot
F1,Foxtrot1
F2,Foxtrot2
F3,Foxtrot3
F4,Foxtrot4
G,Gamma
HD,HurricaneDelta
I,Indigo
I1,Indigo1
IE,IndigoEcho
K,Kilo
K1,Kilo1
K1P,Kilo1Papa
K2,Kilo2
K2P,Kilo2Papa
K2Q,Kilo2Quincy
K3,Kilo3
K3P,Kilo3Papa
K4,Kilo4
K4P,Kilo4Papa
KP,KiloPapa
L,Lima
LCF,LimaCharlieFoxtrot
LCP,LimaCharliePapa
M,Mike
M1,Mike1
P,Papa
PI,PapaI
PR,PapaRoger
R,Roger
S,Sam
S1,Sam1
T,Tango
T1,Tango1
T2,Tango2
T3,Tango3
T4,Tango4
TB,TangoB
TC,TangoCharlie
TCP,TangoCharliePapa
U1,Uniform1
V,Victor
V1,Victor1
V2,Victor2
Y,Yankee
YTD,YankeeTangoDelta
Thank you for any assistance you can provide here.
g
PS
Please don't offer criticism regarding the phonetics. I know they are not official codes.
I have named each cell and given them a description of what they represent. These letters and numbers are used in tax formulas that I'm not able to change. So I have to compromise here a bit.
I cannot reference them by "Y1" in the formula (obstacle: Y1 could actually be located in cell Y2 and "Y" is in cell Y1) I want to adjust the formula on my end. I want to replace "A" with "Alpha", "Y" with "Yankee" and so on (NATO phonetics with some personal adjustments).
My problem is, when I change cells in column E to include "Echo", and if its a combo of "YE1" for example, then I end up with "YankeEcho1".
I'm going to provide the phonetics I will be using below as I would imagine someone would ask for them if I don't
A,Alpha
A1,Alpha1
B,Beta
B1,Beta1
C,Charlie
D,Delta
D1,Delta1
E,Echo
EI,EchoIndigo
F,Foxtrot
F1,Foxtrot1
F2,Foxtrot2
F3,Foxtrot3
F4,Foxtrot4
G,Gamma
HD,HurricaneDelta
I,Indigo
I1,Indigo1
IE,IndigoEcho
K,Kilo
K1,Kilo1
K1P,Kilo1Papa
K2,Kilo2
K2P,Kilo2Papa
K2Q,Kilo2Quincy
K3,Kilo3
K3P,Kilo3Papa
K4,Kilo4
K4P,Kilo4Papa
KP,KiloPapa
L,Lima
LCF,LimaCharlieFoxtrot
LCP,LimaCharliePapa
M,Mike
M1,Mike1
P,Papa
PI,PapaI
PR,PapaRoger
R,Roger
S,Sam
S1,Sam1
T,Tango
T1,Tango1
T2,Tango2
T3,Tango3
T4,Tango4
TB,TangoB
TC,TangoCharlie
TCP,TangoCharliePapa
U1,Uniform1
V,Victor
V1,Victor1
V2,Victor2
Y,Yankee
YTD,YankeeTangoDelta
Thank you for any assistance you can provide here.
g
PS
Please don't offer criticism regarding the phonetics. I know they are not official codes.