Need help, I need to add words to each row

  • Thread starter Thread starter Nobody
  • Start date Start date
N

Nobody

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
 
Hi
If you data is in column A type this in column B and drag down to 400
="I Think"&" "&A1
HTH
John
 
OK I guess I should have been more specific, I currently have data in
columns a,b,c it is column "C" that I want to add the " I think" to every
row in column "C"

Sorry I didn't give you the exact situation

Thanks
 
All you need to do is change the reference from A1 to C1 or any cell number you
like.
HTH
John
 
Thank you,

It worked kinda, it did insert the "I Think" in front of the text already in
the column BUT when I click on the cells instead of getting the text with
"I think" in front of it I get the below in the fx bar space. I need every
cell to have the actual text not fomulas in them
="I Think"&" "&C2
="I Think"&" "&C3
="I Think"&" "&C4
="I Think"&" "&C5
 
Hi Again
Once you got all the information, select all, copy, then go to Edit> Paste
Special > select
Values. This will replace the formula with your Text.
You can paste in the column C to replace with the new phrase. Don't forget to
save after.
HTH
John
 
Just in case.
When I said "Select All ", I mean select all the cells that have the formula
only.
HTH
John
 
John,

Thanks so much that worked perfectly !!!!!!!! you saved me hours of work

Thank you again
 
Back
Top