On Sun, Dec 21, 2008 at 01:12:44PM -0600, Robert Citek wrote: > Is there a way to do inner, left, or outer joins in a > spreadsheet, e.g. OOo Calc?
I had a similar problem to solve and the concatenate formula fixed it for me. Works across sheets too. I think this is what you want: If this: Sheet1.A1 = apple Sheet2.A1 = pear use this in, for example, Sheet3.A1: =CONCATENATE(Sheet1.A1 ; Sheet2.A1) And returns this: applepear And if you want a space in between: =CONCATENATE(Sheet1.A1 ; " " ; Sheet2.A1) And within a single sheet: =CONCATENATE(A1 ; B1) Is that what you want? Sean -- Sun, 21 Dec 2008 14:01:56 -0600 --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
