merge columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard Rosser - 10 Sep 2007 16:22 GMT

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

Reply to this Message

David Biddulph - 10 Sep 2007 16:59 GMT

=A1&B1 (as a formula in cell C1, for example) will do your concatenation (or
=A1&" "&B1 if you want to insert a space between the strings).
If you want to replace A1 by that result, select column C, copy, select
column A, Edit/ Paste Special/ Values, then you can delete column C (and B
if you wish to).

Signature

David Biddulph

> Greetings.
>
[quoted text clipped - 11 lines]
>
> Many thanks in advance

Reply to this Message