O.K.

You see my mis-understanding.

I can solve this with visual basic.

Check back later
--
Gary''s Student - gsnu200744


"ENFGDC4S" wrote:

This is where my problem is. Here is an example of one of the cells:
C5,C16,C30,C38,C54,C91,C98,C136,C147
I can have a few hundred of these alpha numeric characters in one cell.
Thanks for your time.

"Gary''s Student" wrote:

That's O.K. We can solve this.

In A1 thru A3 I entered:

R1
R12
R152


I put my formula in B1 thru B3 and see:

R1 R001
R12 R012
R152 R152

What do you see?


--
Gary''s Student - gsnu200744


"ENFGDC4S" wrote:

I could not get this to work.

"Gary''s Student" wrote:

=LEFT(A1,1) & TEXT(RIGHT(A1,LEN(A1)-1),"000")

--
Gary''s Student - gsnu200744