Need to concat text with calculated number 1

[RCPD700]

Rather than having to type full task numbers into a bunch of cells for tasks on a project, what I want to do is concatenate a calculated number to the right of a milestone number. Example:
2-00010 first task for milestone 2

Now, I want to "calculate" the task numbers for all remaining tasks in this milestone by incrementing the 00010 portion by 10 for each row. I've tried several ways, but keep getting errors or the string showing my attempt
such as '2-&(Right(A7,5)+10)

Any ideaas on how I might accomplish this?

Thanks

Jim

 

[AnotherHiggins]

Concatenated stuff is always TEXT. So whatever isn't being calculated needs to go inside quotes. Also, you'll need to tell Excel if you want to return a special format for the calculated value.

="2-" & TEXT(RIGHT(A7, 5) + 10, "00000")

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[RCPD700]

That nailed it! Thank you very much.
I don't work Excel enough to be really proficient, I'm much better with Access.
A gold star for you.

Thanks again,
Jim

[small]Be kind to your neighbor, he knows where you live[/small]