Mass add in a column

4

49erfan

I am working on a spreadsheet where I have food descriptions in the cell. I
have 1400 rows that I have to add the word "Breakfast" to the end of each. Is
there an easy way to add that word without copying and pasting the word onto
each row? Let me know. Thanks!!
 
D

Dave Peterson

I'd use a helper column:
=a1&" Breakfast"
Then drag down as far as needed.
Select that column
edit|copy
select the original column
Edit|paste special|Values
and then delete that helper column.
 
J

JE McGimpsey

One way:

Say your 1400 entries are in column A. In an empty column (say, J)
enter, e.g., "J1:J1400" (without quotes) in the Name box at the left
side of the formula bar. Enter this in the formula box, using CTRL-ENTER:

=A1 & " Breakfast"

Copy column J. Select column A. Choose Edit/Paste Special, selecting the
Values radio button.
 
Top