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
Stuart
