Not sure exactly what you're talking about without seeing. I've used Excel and
Openoffice and they are really similar. If you have a smaller example, maybe a
few entries with the same type of columns setup, you could send to me, I'd be
glad to check it out and see what it would take. Should be easy enough. Be sure
and tell how you want the new one set up.

I got it. It was super easy --- I was just not thinking clearly.

A B C
First Last = full name

I wanted column A (firstname) and column B (lastname) to be pulled
together into column C = firstname lastname.

It was as easy as =A1&" "B1& in the C column.

I just copy and paste them.............

I typed this in spreadsheet and got


ERR:509

What doeas that mean?

Try =A1&" "&B1......................