Add text to cells
 

I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc
how can this be done

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
---
"Bev" wrote:
I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc
how can this be done

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)&TE XT(MID(A1,4,1),"000")

Bev wrote:

I want to add 000 in cells example L1S1 to become L001S001 L001S002 etc etc
how can this be done

--

Dave Peterson