How to Append same text in every cell in MS Excel

Question

Hi All

I want to add same value/text in every cell in a column of ms-excel

any idea???

edit:::

actually i have data like follows

[email protected]

[email protected]

[email protected]

[email protected], [email protected]

[email protected]

[email protected]

[email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], [email protected], n

[email protected]

and many more........

and i want to add ,(comma) at end

is it possible???

Answer 1

Type it in one cell, copy that cell, select all the cells you want to fill, paste.

Alternatively, type it in one cell, select the black square in the bottom-right of that cell, drag down.

Answer 2

Put the text/value in the first cell, then copy the cell, mark the whole colum and 'paste' the copied text/value.

This works in Excel 97 - sorry no other version available on my side...

Answer 3

Select the range of cells, type in the value and press Ctrl+Enter. This, of course, is true if you want to do it manually. If you want to do it in code, please, be more specific, what do you use.

Answer 4

See if this works for you.

• All your data is in column A (beginning at row 1).
• In column B, row 1, enter =A1&","
• This will make cell B1 equal A1 with a comma appended.
• Now select cell B1 and drag from the bottom right of cell down through all your rows (this copies the formula and uses the corresponding column A value.

That's It!