|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 17th, 2004, 07:51 PM
|
|||
|
|||
6 cells of Name and Address
I need to combine six columns of name and address information into one cell.
I'm using =J2&" "&K2&" "L2&....etc. With an ALT+Enter between each to line feed but nothing seems to format it correctly 
|
|
#2
May 17th, 2004, 08:44 PM
|
|||
|
|||
|
6 cells of Name and Address
Hi
try =J2&CHAR(10)&K2&CHAR(10)&..... and format the target cell with Word wrap ('Format - Cells - alignment') -- Regards Frank Kabel Frankfurt, Germany TAP wrote: I need to combine six columns of name and address information into one cell. I'm using =J2&" "&K2&" "L2&....etc. With an ALT+Enter between each to line feed but nothing seems to format it correctly
|
|
#3
May 17th, 2004, 10:26 PM
|
|||
|
|||
|
6 cells of Name and Address
Frank
That did the trick! Thanks for the tip. Tom Chicago Il USA
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
