One way:

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

In article ,
phillr wrote:

Hello. I have a tape label spreadsheet where the cells are laid out as:

CS2_A001
CS2_A001
CS2_A002
CS2_A002
CS2_A003
CS2_A003
etc.. etc....


So basically each cell is doubled. I'd like to setup a template where if I
manually type in the first cell (or assign an arbitrary number such as 020),
all the other cells will automatically change. How do I do this?

I tried doing "=A1+1" but I just get the value error :(. The formula doesn't
need to automatically double (in fact it shouldn't for customization
reasons). Just a formula where it would do something like: 'TEXT + 1', so
'CS2_A' would be the standard text, three number placeholders standard (000).