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

  1. J

    String Manipulation or VB?

    I learn something new everytime I read a response from you "Ninjas". Thank You Narayank991. That answers my 2nd question. Enjoy your day
  2. J

    String Manipulation or VB?

    I have another question with the code that was provided... I am wanting to use this function in a table and instead of using: StringRemovalNotSoSimple(C1) I would like to use the Table headers StringRemovalNotSoSimple([Solution]) I am receiving "#VALUE!" error by using this...
  3. J

    String Manipulation or VB?

    This does exactly what I was looking for. I will be learning a lot from your code. Thank you SirJB7. BTW I also learned from a colleague that I could have used "find and replace" twice instead of using a function. I didn't know that I could use wild cards in a search. Find: /#*#/...
  4. J

    String Manipulation or VB?

    Thanks for the reply SirJB7... The numbers and # need to come out of the string. This is what I have come up with so far... I don't like this approach but cannot think of how to solve. Copy this formula into column E with the data in column C...
  5. J

    String Manipulation or VB?

    I am extracting data from sharepoint and need a formula to change this string: Text string;#40;#Some more text;#284;#and some more;#1003;#and some more again;#410 to this sting Text string Some more text and some more and some more again the numbers between ;# can vary from 1 digit to...
See more
Back
Top