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?