Quote:
Originally Posted by EddyTheDog
= CONCATENATE (A1,B1)
Put that in C1
Where
A1=cock
B1=http://ccn.com/
C1=http://cnn.com/cock
|
Eddy is right that concatenate is the correct formula to use (well it is in excel anyway) but based on the data on his column contents his formula should have been =concatenate(b1,a1) not as he put it.
I haven't used open office for many years and whilst most excel formulas do work sometimes they need a little tweak so if you can't get concatenate to work, izombie's solution is just as good, namely
1.keep domain data in column a
2.add cocks etc in column b
3. column c type +a1&b1
4. copy column c down the page as far as you need to.
If you want to do this many times with different data you can just copy and paste value (to another column or spreadsheet) your column c data and rinse and repeat over and over