This week I received an email from someone who had 258 cells containing strings that they wanted to combine into a single cell. Rather than using VBA, I worked out another way to do it. This video shows you how. Note that the CONCATENATE function has a limit of 255 arguments so you’d have to use the solution from this video plus some manual concatenation.