Hi Diana On Mon, Aug 24, 2009 at 6:38 AM, Diana Gale Matthiesen < Diana@danishdemes.org> wrote: > > > =CONCATENATE(A2," ",B2) That was the system that I used (and yes - I do have a copy of the file before combining cells). > > > Be certain the new column is formated "General" on the Number tab; > otherwise, > the cell will contain the formula, not the result. That would appear to be my error - not formatting the new column first. Thanks for your help. Anne > > > -- Anne PICKETTS Waipu, NZ NZSG #5331; KFHS #6151