join text

  1. B

    Ignore blank cells on formula to join text from different cells

    Hi everyone, I've got the following formula and can't find a way to ignore the blank cells if not data is entered. I'm trying to avoid having double comas when no data is in one of the cells. using formula (=CONCATENATE(A1, ", ",B1, ", ",C1) <tbody> Column 1 Column 2 Column 3 Formula result...
  2. A

    Creating a Heading in Excel with an Array

    Hello Everyone. I apologize if this is a subject that has been addressed already, I did a search and was not able to find a solution to my problem. This may be a fairly elementary question for all of you experts out there but I am not the strongest programmer. I am attempting to create a title...
  3. M

    Loop down rows on multiple selected cells

    I have a sub that will join the text together from multiple columns into one cell but it only works for one row. I would like it to work through the rows selected. How do I do this? Sub JoinText() myCol = Selection.Columns.Count For i = 1 To myCol ActiveCell = ActiveCell.Offset(0, 0) &...

Some videos you may like

This Week's Hot Topics