Mass inserting one piece of information

[jediknight]

HI all,

I have a spreadsheet which in column C has many rows 10000+ of written information, I am looking to insert for example one word lets say "Hello" into each of the columns which contact all this written information but just need this word to be placed infront of all the written information but in the same column

example:

Column C, row 1 to 10 has "We have a test" in each row written
and
Column C, row 11 to 20 had "We do not have a test" in each row written

Now so that I do not need to click on each row and add the word "Hello" can I tell it to mass insert the word "Hello" in from of those phrases in each row giving me:
Column C, row 1 to 10 "Hello we have a test"
Column C, row 11-20 "Hello We do not have a test"


I hope this is simple to do and would like to avoid macros if possible.

Thanks.

[Ace_XL]

In a separate column

="Hello "&C1

Copy down

Copy this column and 'paste special --- values' onto the original column (Col. C)

[martindwilson]

in say d1 put "hello" in e1 put =$D$1&" "&C1
fill down
you can copy col e then past special values over column C, then delete data in d1 and col e
or just put in col d starting d1
="hello "&c1

[jediknight]

Many thanks for all the help, works perfectly. Just done it all in 2 min instead of hours of cut and past each one.