Combing Columns

[Random777]

Yah, this is basic, but I can't find the answer in the Help or the Forum so....

Goal: Combine 2 Columns ( Address1 & Address 2) into one column.

First Attempt: Highlight the two columns and right-click, I expect there to be a 'Merge Columns' option. There isn't. Huh? Is that not an obvious thing to do with 2 columns?

Ok, so I make a 3rd column and fill it with =CONCATENATE(A1;B1)

Great, but now when I delete columns A and B, I have invalid refs in Column C.

Okay, so I Copy Column C, and do a Paste Special -> Values Only into Column D, then I'll just delete the first 3 columns.

Except 'paste values' does not exist! How the heck can that not exist?

So....

Is there an easier way to merge columns than =CONCATENATE(A1;B1) ?

If not, how the heck do you paste the results of an operation rather than the function that created it?

(Rhetorical question by annoyed user: When I search Help for "Join/Merge Columns" and for "Paste Values" why don't I find the answers to these questions so I don't have to bother actual humans? These seem like obvious things to do, yet how to do them is not obvious.)

Thanks,
Random

[scsisys]

Try.....

=A1&" , "&B1 in C1. Then, click on C1, COPY, Paste Special (untick Paste All and
Formulas) and tick TEXT. Click OK

scsisys
_________________
OO 3.2.1
Win XP /SP3

[Random777]

Ah, So unchecking Formulas is how we say, 'paste values'.

Cool that is helpful, thanks.