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
Bookmarks