• 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.

Recent content by sonnyatoak

  1. S

    Excel Concatenate with set number of characters.

    Got both, I'll take a look. Many thanks. I'll let you know if it works or if I have any questions.
  2. S

    Excel Concatenate with set number of characters.

    Faseeh, haven't received anything. Could you resend or upload here. Thx
  3. S

    Excel Concatenate with set number of characters.

    Faseeh, did you get me email regarding some of my concerns and questions?
  4. S

    Excel Concatenate with set number of characters.

    I sent a few minutes ago, let me know if you didn't receive. Thanks again.
  5. S

    Excel Concatenate with set number of characters.

    Thanks Faseeh, I have several questions which might be easier if I sent by email where I could inclose a picture (using snagit) what I'm asking about. Let me know if thats OK? I'm I mistaken or can I assume you just have a sample of what I earlier posted? Looks like 316 items and of course...
  6. S

    Excel Concatenate with set number of characters.

    I don't know how to use VBA. Do I need any prior knowledge?
  7. S

    Excel Concatenate with set number of characters.

    The file I downloaded earlier my have been read only. Will that infer with making changes on it?
  8. S

    Excel Concatenate with set number of characters.

    Faseeh, I didn't mean I was frustrated with anyone who has helped. You guys have been great. I was frustrated at me for not being able to complete the instructions. I hope no one misunderstood my comment as being directed at them. I truely apologize if it was taken that way.
  9. S

    Excel Concatenate with set number of characters.

    That's right. Seems simple stating that but I keep messing up when copying and pasting. Information can be put on another sheet as long as the information is there.
  10. S

    Excel Concatenate with set number of characters.

    I am very frustrated. The information you have provided is probably correct but I keep coming up with errors. I have downloaded the file for preview. Again, what I am trying to do is eliminated duplicate routing numbers but retain the text. I was able to accomplish the first step; COLUMN F...
  11. S

    Excel Concatenate with set number of characters.

    Faseeh, many thanks. Exactly what I wanted. Have a great week!
  12. S

    Excel Concatenate with set number of characters.

    Goal is to cut down over 12000 routing entries (sheet 1) down to 4000 (sheet 3)by eliminating duplicate part numbers. Probably easier to understand starting from sheet 1 information. In column A, I have a list of routing numbers. Some numbers appear more than once (because of comments in...
  13. 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...
Back
Top