Okay, I give up. I have 3 columns with data in all the cells in all the rows. All the columns are formatted as text.

For Example:

----A-----B-----C----D

1--(75---23---JB

2--(7a---35---JC

3--(xx---27---JD

I entered =CONCATENATE(A1;B1;C1) as a formula on the input line for Cell D1 and hit <ENTER>. The formula appears in D1. I expected to see (7523JB in the cell. Instead I got:

----A-----B-----C----D

1--(75---23---JB---=CONCATENATE(A1;B1;C1)

2--(7a---35---JC

3--(xx---27---JD

In Microsoft Excel, after typing the function in the input line and pressing <ENTER>, the function is processed and the concatenated text appears in cell D1. Then I drag the lower right corner of cell D1 downward and all the other rows are concatenated. Here's what I would get in Excel:

----A-----B-----C----D

1--(75---23---JB---(7523JB

2--(7a---35---JC---(7a35JC

3--(xx---27---JD---(xx27JD

HOW do I do this very simple thing in OpenOffice Calc? I've tried entering just the column letter in the formula. I've tried highlighting column D and entering a formula using column numbers (1 for the first column, 2 for the second column, etc. That works in Excel). I've even tried using A1&B1&C1 instead of A1;B1;C1.

I feel ashamed to say it, but I've been an Oracle DB and application programmer for 15+ years, but I'm lost here.