Hi,

Well I've seen this one before, its a pretty ugly formula and adding
&CHAR(10)& between various parts of it makes it all the more ugly. First if
you are trying to put a space between every two entries "" "" will not work,
use " ". A pair of double quotes, not two pairs.

--
Thanks,
Shane Devenshire


"Christi" wrote:

When I type what you said, I get this #NAME?

Here is my original formula:
"CONCATENATE($N$5,"" "",N7)&CONCATENATE($O$5,"" "",O7)&CONCATENATE($P$5,""
"",P7)&CONCATENATE($Q$5,"" "",Q7)&CONCATENATE($R$5,""
"",R7)&CONCATENATE($S$5,"" "",S7)&CONCATENATE($T$5,""
"",T7)&CONCATENATE($U$5,"" "",U7)&CONCATENATE($V$5,""
"",V7)&CONCATENATE($W$5,"" "",W7)&CONCATENATE($X$5,""
"",X7)&CONCATENATE($Y$5,"" "",Y7)&CONCATENATE($Z$5,""
"",Z7)&CONCATENATE($AA$5,"" "",AA7)&CONCATENATE($AB$5,""
"",AB7)&CONCATENATE($AC$5,"" "",AC7)&CONCATENATE($AD$5,""
"",AD7)&CONCATENATE($AE$5,"" "",AE7)
&CONCATENATE($AF$5,"" "",AF7)&CONCATENATE($AG$5,""
"",AG7)&CONCATENATE($AH$5,"" "",AH7)"

This is my result:

Janitorial 0Groundskeeping -90Building Engineer 0Elevator 0HVAC 0Pest
Control 0Plumbing 0Trash 0GB R&M 0Pavement 0Security 0Electricity 0Gas 0Water
0Fuel/Steam 0Occ-Other 0F&E Main. Contract 0F&E Main. 0Small Furniture 0F&E
Rental 0Misc. 0

I want my result to be:
Janitorial 0
Groundskeep -90
Building Engineer 0

etc.





"Gary''s Student" wrote:

=A1 & CHAR(10) & B1
and Format Cells... Alignment Wrap
--
Gary''s Student - gsnu200808