I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc how can this be done
B Bev May 7, 2007 #1 I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc how can this be done
M Max May 7, 2007 #2 One way .. In any starting cell, say in B2: ="L"&TEXT(ROW(A1),"000")&"S"&TEXT(ROW(A1),"000") Copy B2 down as far as required
One way .. In any starting cell, say in B2: ="L"&TEXT(ROW(A1),"000")&"S"&TEXT(ROW(A1),"000") Copy B2 down as far as required
D Dave Peterson May 7, 2007 #3 Always 4 characters--alpha, numeric, alpha, numeric? If yes: =LEFT(A1,1)&TEXT(MID(A1,2,1),"000")&MID(A1,3,1)&TEXT(MID(A1,4,1),"000")
Always 4 characters--alpha, numeric, alpha, numeric? If yes: =LEFT(A1,1)&TEXT(MID(A1,2,1),"000")&MID(A1,3,1)&TEXT(MID(A1,4,1),"000")
