I have a column of data (col1) with text entries like " California Metal
Works, Inc."

I have another (col2) with entries like "Metal extrusions."

What I want is a single cell with "California Metal Works, Inc. - Metal
extrusions." in col1

I've tried to cut/paste but I can not paste without overwriting the data in
original cell.
I've tried edit mode but I can not paste there
I tried concatenate but get a data error
I tried merging cells but I get message that only leftmost cell will be kept

So far I'm stuck manually typing the contents of col2 into col1 in edit
mode.

There must be a better way.

Each entry in col1 is unique as is col2 so search/replace is the same as
manually typing the data.

Any help appreciated.

Thanx,

Vic Baron


--
There are 10 kinds of people who understand binary. Those who do and those
who don't!