autofill using alpha & numeric characters?

[sherilynne]

I need help! I know how to autofill with just numbers (ie: 0100001, 0100002, 0100003). But I cannot figure out how to autofill (if you can even do it) with both numbers and letters (ie: FS0400001, FS0400002, etc). I actually need 2 of each "number" (FS04000001, FS0400001, FS0400002, FS0400002, etc). I'm looking for something simple - drag & fill, cut/paste....no fancy formulas please . Edited to add that I need it in a column not rows. TIA!!

Thank you for any help you can give me.

 

[jimboy]

Try this formula in B3

="FS0" & VALUE(RIGHT(A2,8))+1

and this in B4

="FS0" & VALUE(RIGHT(A3,8))

Then select B3 & B4 and drag downwards...

Book11
	A	B	C	D
1	FS04000001
2	FS04000001
3	FS04000002	Select B3 & B4 and drag downwards
4	FS04000002
5	FS04000003
6	FS04000003
7	FS04000004
8	FS04000004
9	FS04000005
10	FS04000005
11	FS04000006
Sheet6

 

[santeria]

Well, I tried it in Columns.

Typed in FSO4000001
then dragged the box thingie ( technical term ) down to FSO4000022 down the column, works perfectly.

Okay, my mistake... so you need two sets of numbers... silly me...


Okay, I just tested with Two number values along side of each, works, sort of , but the first number stays the same, and the second number increments... I guess you could always concatenate ??

 

[jimboy]

PS. After you have dragged downwards, you could copy >pastespecial>values to change to values...