Mass add in a column
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.
49erfan wrote:
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!!
--
Dave Peterson
|