merging 2 columns, multiple cells with text -- possible?

  • Thread starter Thread starter skeeelz
  • Start date Start date
S

skeeelz

Can anyone tell me if it's possible to merge two (or more) columns, eac
with multiple rows, each cell containing text? (Without using a formul
for each and every row -- that is, doing it in one fell swoop.) Th
issue I have is importing tables from Quark listing stats for upward
of 150 companies. The "A" column will have a company name, the "B
column its location. To place this on the web, and to conform t
existing style, the company name and location need to be in the sam
cell. Any suggestions?
(I have Excel 2000
 
Yes, you can but what is wrong w/ a formula in each cell?

Just type it once and copy it down <ctrl-d>

CONCATENATE
See Also

Joins several text strings into one text string.

Syntax

CONCATENATE (text1,text2,...)

Text1, text2, ... are 1 to 30 text items to be joined into a singl
text item. The text items can be text strings, numbers, or single-cel
references.

Remarks

The "&" operator can be used instead of CONCATENATE to join tex
items.

Example

The example may be easier to understand if you copy it to a blan
worksheet
 
Hi

though this solution will require a formula maybe it will help you
1. In C1 enter the following: =A1 & " - " & B1 (replace the delimiter
' - ' with any character you like)
2. Select this cell and double click on the fill handle (lower right
corner of the selection). This will copy the formula for all rows
Thats ist

HTH
Frank
 
Use this formula, but it's still accomplished in "one fell swoop", as long
as there are no empty rows in between.

Data starts in A1 and B1.

In C1 enter:

=A1&" " &B1

Now, select C1, and place the cursor over the little black square, in the
lower right corner of the cell, until it changes from a fat white cross, to
a skinny black cross.
Then just double click.
This will automatically copy the formula in C1, all the way down column C,
as far as there is data in column B.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




Can anyone tell me if it's possible to merge two (or more) columns, each
with multiple rows, each cell containing text? (Without using a formula
for each and every row -- that is, doing it in one fell swoop.) The
issue I have is importing tables from Quark listing stats for upwards
of 150 companies. The "A" column will have a company name, the "B"
column its location. To place this on the web, and to conform to
existing style, the company name and location need to be in the same
cell. Any suggestions?
(I have Excel 2000)
 
Back
Top