Microsoft Excel 2008, 2010 - Increment numbers inside a string

Perhaps you can work around with something like that:
A1: "user"
B1: 1
C1: "@localdomain.com"
D1: =$A$1&TEXT(B1,"000")&$C$1
[Edit: This applies for the english version of Excel, otherwise the last line should read =$A$1&TEXT(B1;"000")&$C$1, note the semicolon instead of a comma. Thanks @Kevin for clarifiying this point.]
Then you can drag-and-click column B and D, where D will look like
user001@localdomain.com
user002@localdomain.com
user003@localdomain.com
user004@localdomain.com
user005@localdomain.com
...
Nguồn: http://superuser.com/

Comments

Popular Posts