Another excel question

**Langrad** · 02-22-12, 02:38 PM

See enf, no one likes that, here we are working out how to do it with an function or three, no matter how long the function ends up being, and you waltz in here with a macro and drop it on us. For shame.

**enf** · 02-22-12, 02:40 PM

haha

I am an Excel vba junkie, sorry.

**Cojiro** · 02-22-12, 02:41 PM

testing error handling of exceeding limits.

its kind of a taste of what it would be like to be a video game tester. from the outside it seems kind of fun. But then you go in your first day and they tell you that today you will walk to every possible standing position in the world and press the jump button and make sure the game doesnt explode as a result.

By the way thanks guys got it goin now.

**RhysJD3** · 02-22-12, 04:48 PM

=CONCATENATE("cojiro",ROW(),"tpg")

If there's one way to do it in Excel, there's probably 10-100 ways

**enf** · 02-22-12, 05:06 PM

F5
type in A20000 and hit enter
="cojiro"&ROW()&"tpg"
CTRL+C
CTRL+SHIFT+UP ARROW
CTRL+V
CTRL+C
Paste Values

DONE SON!!!

Yeah, definitely have an Excel problem...