Raymond Norton wrote: > I know this is off topic, but I need to import a few hundred names into > a program. I need a formula in Calc that will take the first three > letters of all cells in column 4, and the first two letters of all cells > in column 2, and produce the output in a third column. I certainly would consider OOo (and ODF) on topic. I don't have a great reference on the macro language... but I have several friends that have driven OOo by remote control via the UNO bridge [1] in Python or Java. HTH, --Tom [1] http://udk.openoffice.org/ http://weblogs.java.net/blog/tchangu/archive/2005/12/open_office_jav_1.html