Auto generated number in Excel/MS Word?

[fleabag]

Is there an automated way to replace a given word and or generate numbers in Microsoft excel? Like I have a phrase I want to say and I want to add a number in the middle of the phrase, but I want to do it multiple times changing the number each time the string is generated.

Example:
Filechunk1mark
Filechunk2mark
Filechunk3mark

etc..

I don't know how to use the macro function in Microsoft Excel and I'm wondering if the only way to get this accomplished is through that.

 

[nickbits]

Doubt this is the best way, but what i do:

Fill "FieldChunk" in col A
Generate number sereis in col B
Fill "mark" in col C
Col D=CONCATENATE(A,B,C)

 

[Billb2]

Excel, =rand()

 

[armstrda]

=CONCATENATE("fieldchunk",ROW(),"mark")

This will number them based on what row the thing is in.

 

[fleabag]

Woah, you guys confused me because you kept saying "fieldchunk" instead of Filechunk like I wrote so I thought you were saying a "command"...

Found this to work best in auto generating sequences...
http://www.codejacked.com/auto...sequences-in-ms-excel/

 

[armstrda]

that The method on that website doesn't describe what you were asking for though...