info in multiple cells to one

[deuce1977]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi, I have contact info broken out in to individual cells and I would like to combine them all in one without having to copy and paste over 100 rows of contact info. Is there a fast way to do this?

Thx

 

[Carl Witthoft]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi, I have contact info broken out in to individual cells and I would like to
combine them all in one without having to copy and paste over 100 rows of
contact info. Is there a fast way to do this?

Thx

=CONCATENATE(A1:J1)

Is that what you want?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hi, I have contact info broken out in to individual cells and I would like to
combine them all in one without having to copy and paste over 100 rows of
contact info. Is there a fast way to do this?

Thx

You can create another column with a formula like =A1&B1&C1 etc. this will
put the data into a single cell. Fill the formula down for as many rows as
you need. You can then copy it and Edit-Paste Special-Values to itself to
delete the formulas. Then if you want delete the original columns.

 

[deuce1977]

Thanks to both of you. I tried both ways and the =A1&B1&C1 gets me closest to the objective. No I have the info in to one cell, but when I go in to "return" the info to a new line within the cell, it just has the cell references.

A1 = name
A2 = phone number
A3 = email
A4 = address

Would like to have them returned to new lines within the cell automatically like above...is that possible?

 

[Bob Greenblatt]

Thanks to both of you. I tried both ways and the =A1&B1&C1 gets me closest to
the objective. No I have the info in to one cell, but when I go in to "return"
the info to a new line within the cell, it just has the cell references.

A1 = name
A2 = phone number
A3 = email
A4 = address

Would like to have them returned to new lines within the cell automatically
like above...is that possible?

Then the formula should be:
=a1&char(13)&b1&char(13)&c1

Format the cell to wrap text and adjust the row height as needed.