"Gary''s Student" wrote:

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...

this almost does what I need.
I need it to read the U,V,N,R,G,L and so on and many other letters and fill
in B1 with letters and numbers like E86, E44, E87. They are not in order as
in E86,E87,E88 ans so on.
It could be E44,E86,E90....