Hi,

I have an alpha-numeric numbering scheme as follows:

Cell M42 = C
-- Represents the revision letter, in this case, Rev. 'C'

I thought I could do a nest text formula, kind of like the following, but it's not working well:

=TEXT($M$42,"")&TEXT(E68+1,"##")

The intent was to drag this down the column, as I would be able to do if I had:

E68+1 by itself.

Except now, I want to have the Rev letter in front of it.

How can I modify?

Thanks