Add text to cells  
Author Message
J12





PostPosted: 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





PostPosted: 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





PostPosted: 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