I am not sure I have your pattern, but if you want the fifth character of A1
to produce the following text in B1:

A E66
B E67
C E68
D E69
E E70
F E71
G E72
H E73
I E74
J E75
K E76
L E77
M E78
N E79
O E80
P E81
Q E82
R E83
S E84
T E85
U E86
V E87
W E88
X E89
Y E90
Z E91
Then enter the following in B1:
="E" & CODE(MID(A1,5,1))+1

--
Gary's Student


"nick s" wrote:

I am a newbee at this so bare with me......

Here is what I am trying to do with no luck so far.
If I type RS23U1R109000 in a cell A1, I want B1 to read the 5th letter or
number and fill B1 with E86.

Example
A1= RS23U1R109000 B1=E86
A1= RS23V1R109000 B1=E87
A1= RS23R1R109000 B1=E84

As you can see in my example, the 5th letter could be U,V,R or whatever, but
I need cell B1 to read that letter and populate B1 with E86, E87, E84 or
whatever.

I hope I haven't confused anyone...