Is there a better way to create a "series" that is based on characters
as well as digits than what I'm doing below?

I created 3 columns.  I put the text in one, the digits in the second
that I could apply the series to, with the 3rd column holding a ":".
But when I paste into the text file, I have tabs separating the 3
columsn where I was hoping for no space.

So this here -

NAQAHDAH    01    :
NAQAHDAH    02    :
NAQAHDAH    03    :

should paste like this -
NAQAHD6H01:
NAQAHDAH02:
NAQAHDAH03:
NAQAHDAH04:
NAQAHDAH05:
NAQAHDAH06:
NAQAHDAH07:
NAQAHDAH08:
NAQAHDAH09

Is there perhaps a way to do this while keeping the 3 elements
together in each cell of the column?  Or perhaps there's another way?

Thanks. :oD