You should put a bracket after the CHAR(10) before &City and not at the end. Perhaps your Address2 and Address3 are not actually blank, but contain a one or more spaces (or char(160)). Hope this helps. Pete "Wanna Learn" <WannaLearn@discussions.microsoft.com> wrote in message news:BDDD8D57-37F5-41F7-900F-0AD5635B916E@microsoft.com... Thanks for your prompt response. I added the
Use a test. Say we usually have a first name in A1, a middle name in A2 and a last name in A3. Our reduced formula would be: =A1 & CHAR(10) & A2 & CHAR(10) & A3 Now if there is no middle name, then: =A1 & IF(A2="","",CHAR(10) & A2) & CHAR(10) & A3 -- Gary''s Student - gsnu200794 "Wanna Learn" wrote: Hello This is my formula =FirstName&CHAR(10)&LastName&CHAR(10)&Address1&CHAR
Hello This is my formula =FirstName&CHAR(10)&LastName&CHAR(10)&Address1&CHAR(10)&Address2&CHAR(10)&Address3&CHAR(10)&City&" "&State&" "&TEXT(Zip,"00000") the problem is that when there is no address 2 or address 3 then I get a blank line .example below "Mr. Jack Sparrow Black Pearl Ltd 1400 Seaport Boulevard 0 0 Redwood City CA 94063" Is there a way to correct this? thanks in
Redwood Symphony, an all-volunteer community orchestra, will be performing Olivier Messiaen's 80-minute, ten-movement symphony/piano concerto/synthesizer extravaganza work, Turangalila Symphony, on June 8 at Canada College, where the orchestra is based. I'm writing to invite you to the performance, and to ask you to consider the unique situation of both this concert and the group performing
On 3/16/2008 15:16, Confirmation said: Return-Path: <newsletter@elabs5.com> Received: from mail31.elabs5.com (208.66.204.205) by studio42.com with ESMTP (Eudora Internet Mail Server 3.2.10) for <REMOVED>; Sun, 16 Mar 2008 15:15:43 -0800 To: <REMOVED> Subject: Please confirm your entry into the Mini Cooper Prize draw Date: Sun, 16 Mar 2008 15:16:04 -0700 Return-Path: newsletter@elabs5.com
