View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nobody[_2_] Nobody[_2_] is offline
external usenet poster
 
Posts: 20
Default Need help, I need to add words to each row

Hello,

I have a worksheet that has several hundred rows and in 1 column I want to
add 2 words before the text that is already in the rows in this column.

For example,

if in column A row 1-400 I have in each row a differnt line of text i.e.

the day is long
the night is short
a dog is cool
a cat is ok

Now I want to add the 2 words "I think" in front of every row of text so it
should look like

I think the day is long
I think the night is short
I think a dog is cool
I think a cat is ok

Hope I explained it ok

Thanks in advance