Excel 2007 : Fill the cell to equal 13 characters

[RBburn]

I have cells of many character lengths that I need to change so they are a total of 13 characters in length and they must all begin with S01.

An example of what I have:
12345
2510236
149841310
1151
105463

And what it needs to be:
S010000012345
S010002510236
S010149841310
S010000001151
S010000105463

Any idea on a function/formula that will help me accomplish this?


Thanks in advance!

[NBVC]

Try in a separate column

="S01"&TEXT(A1,REPT(0,10))

copied down where A1 contains first value to fix.

You can then copy and paste special >> Values over original, if needed.

[RBburn]

Thank you so much for your help!