Inseting data in cells

[bt707]

I have a row of cells that have last names in them, is there a way I can
insert some data into all of the cells, this data will be the same for
all names.

Ex

Before jones1
After (alias=jones1)

then if possible export all of the names to a word or text file all in
one line.

Ex (alias=jones1)(alias=smith2)(alias=johnson3)


Thanks for any help!!!!

 

[Max]

Assuming last names are in A2:Z2

Put in A3 :="alias="&A2
copy across A3:Z3

With A3:Z3 selected, click copy

In Word, click Edit > Paste Special > Unformatted Text

 

[dizzykid]

If the data was in A1:A10, I would enter in B1:
="(alias="&B1&")"
Then copy it across. Then select the B1:B10 range and Edit>Copy.
Select C1, Edit>Paste Special (Values only)
I would then delete rows A and B. I'm not sure about the text file part,
but I think you can just use SaveAs and change to a .txt filetype.

HTH
Chris