copying multiple cells

A

acw

Tom

Have you looked at concatenating the cells together.

=A1&B1&C1
will combine the contents of A1, B1 and C1 together. You
will get the same result from
=CONCATENATE(A1,B1,C1)

Tony
 
T

Tom Ogilvy

You mean besides =A1&A2&A3& . . . &A49&A50

the answer would be no unless you want to use VBA code.

If you mean to concatentate 3 column values per row for 50 rows, put the
formula (=A1&B1&C1) in the first cell (D1) and drag fill down the column.

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Pasting a range to a single cell 0
Embed the same Excel multiple times 0
Tracked changes by multiple people modified to one 0
Copy addition formula of non-consecutive horizontal cells 2
Need Help with a VBA subroutine 0
I'm John, My first post. 0
How to implement two shifts per day with multiple teams 0

Top