Paste same in all cells in column

S

S1L1Y1

I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?
Sol
 
B

Bob I

Start with a copy of the Workbook and in a helper column put

=a1&" extra word"

and copy down, then copy that set of Cells and Paste Special values,
delete Helper column.
 
S

S1L1Y1

Thank You very much. I would very much appreciate if you explain better like
what is a helper and workbook/
Sol
 
B

Bob I

Workbook=Excel File
Helper Column = an empty column on the worksheet that you use to hold
changes and reference the target column.
 
S

S1L1Y1

I finally figured it out. Now I am having another problem. The word that I
want to add I want it to add at the beginning of the cell what is now
happing it is added to the end of what there is there now.
Solomon
 
S

S1L1Y1

I an sending an example I have now in the first cell the following "356" but
I want to add the word catalog so that it will say catalog 356. What it
happing now it will say 356 catalog.
Sol
 
B

Bob I

Problem from phrasing of the original question.

I am working in Microsoft Excel. Now I want to add to each cell in the
column the same word. How can I do it?

should be "How can I insert the same word in front of the current contents?"

helper column first cell should be thus

="catalog "&A1
 
Top