Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Combining Columns In Calc

Hi I have a set of data and I need to combine some cells but not others, with the result of the combined cells I also need to insert the word "and ' between the to lots of data. I have attempted to use =CONCATENATE(O5," and", P5) but I get a redundant "and" in the results cell where I have not combined data from two cells see below C:\fakepath\husband and wife.ods

What I want to do is below

C:\fakepath\husband and wife correct format.ods

I cut and pasted to get the above but I am dealing with sheets of up to 1000 rows and do not have the time to cut and paste

Thanks for your help