Raymond, In calc, you should be able to grab and drag the small black dot/square at the bottom right corner of that cell that already has the formula (on mine, the cursor turns into a crosshair oOo v1.1.2). Now drag that down as far as you need to go to repeat the formula. A dialog pops up, select "formulas" under "Series Type". That should repeat that cells fourmula down for all the other rows. Damien ----- Original Message ---- From: Raymond Norton <admin at lctn.org> To: TCLUG List <tclug-list at mn-linux.org> Sent: Thursday, April 20, 2006 8:28:42 AM Subject: Re: [tclug-list] Need formula for Open Office Calc On Thu, 2006-04-20 at 09:07 -0500, Richard Hoffbeck wrote: > This does it in Excel so it should work in Open Office, although that > doesn't mean that there isn't a better way to do it in OO. You'll need > to patch up the starting rows. > > =CONCATENATE(LEFT(D1,4),LEFT(B1,2)) OK, I got this to work for a single record CONCATENATE(LEFT(D1;4) ;LEFT(B1;2)). How do I apply this formula to the whole column? _______________________________________________ TCLUG Mailing List - Minneapolis/St. Paul, Minnesota tclug-list at mn-linux.org http://mailman.mn-linux.org/mailman/listinfo/tclug-list