|
|
Author |
Message |
J12
|
Posted: Sun May 06 20:45:00 CDT 2007 |
Top |
Excel Misc >> Add text to cells
I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc
how can this be done
Excel379
|
|
|
|
|
demechanik
|
Posted: Sun May 06 20:45:00 CDT 2007 |
Top |
Excel Misc >> Add text to cells
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
> I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc
> how can this be done
|
|
|
|
|
Dave
|
Posted: Sun May 06 21:00:40 CDT 2007 |
Top |
Excel Misc >> Add text to cells
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")
>
> I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc
> how can this be done
--
Dave Peterson
|
|
|
|
|
|
|