merge columns

Greetings.

I have data in Column B (same text in each field) that I want to
add to all of the fields in Column A (different text in each field)

I have tried merge & center and tried to work out how to do a
CONCATENATE but am totally stuck. Is there any way to
add the sentence in Col B to the end of the text in Col A
without cutting and pasting on every line??

Tell me there is an easy way to do this!!

If its a formula I need to use - where on earth do you write it??

Many thanks in advance


.

Relevant Pages

  • Re: merge columns
    ... CONCATENATE but am totally stuck. ... without cutting and pasting on every line?? ... If its a formula I need to use - where on earth do you write it?? ...
    (microsoft.public.excel.newusers)
  • Re: WALKING IN GODS WAYS
    ... You appear to be cutting and pasting from: ... A Guide to Sidrot and Haftarot By Ronald H. ... KTAV Publishing House ...
    (soc.culture.jewish.moderated)
  • Re: TOOL FOR CUTTING EARTH & BURYING RADIALS ????
    ... cutting the earth and burying an antenna radial at the same time. ... wire through the tube, and as the tool cuts the earth, it dispenses and buries ... A tractor- or horse-drawn plow blade, modified slightly, has been used ...
    (rec.radio.amateur.antenna)
  • Re: TOOL FOR CUTTING EARTH & BURYING RADIALS ????
    ... cutting the earth and burying an antenna radial at the same time. ... wire through the tube, and as the tool cuts the earth, it dispenses and buries ... A tractor- or horse-drawn plow blade, modified slightly, has been used ...
    (rec.radio.amateur.antenna)
  • Re: i read in the wrestling observer newsletter
    ... Randy Orton makes the wwe divas lives a living hell and refers to them ... just cutting and pasting. ...
    (rec.sport.pro-wrestling)