• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. S

    Excel Concatenate with set number of characters.

    Trying to figure out how to solve Concatenate formula that would have 80 characters. Since many of the cells would include more than 80 characters, I need the overflow to go to the adjacent cell. On sheet 3 of this file, I have eliminated duplicate routing numbers (found on sheet 1), but...
  2. S

    Excel Concatenate IF

    There has to be a way to do this on my spreadsheet. Column A has a list of part numbers. For example, part number is 1234 is listed 3 times (A1:A3) in the column A, Part 22334 is listed 5 times (A4:A8), and part 54344 is listed 6 times (A9:A14. IN column B, I have text written, but the text is...
Back
Top