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!!

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

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.


In article ,
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!!

one way
for each c in range("a2:a1400")
c.value=c & " Breakfast"
next

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"49erfan" wrote in message
...
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!!

THAT WORKED JE!! THANK YOU SO MUCH!!!