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

    To convert text string to date format

    never mind... just realized that I can use DATE... I guess I spend too much time using IF, IF ERROR, etc, etc...
  2. C

    To convert text string to date format

    @ Rogerimee (and everyone else) - The text to columns application (from DATA ribbon) works great and I am able to get month, day and year in three columns (all values). But how do I put together these columns in one single column for the date? RAW DATA VALUE/TEXT? VALUE TEXT to...
  3. C

    Extract add numbers from alphanumeric strings in single cell w/ multiple lines

    @ SirJB7 - Thank you for the reply. I didn't reply earlier but the formula worked well. I was aware of the Value/Error and it comes with the data entry so that's part of scrubbing the data. Thanks again.
  4. C

    Extract add numbers from alphanumeric strings in single cell w/ multiple lines

    @ Fred thank you for the formula. But it only works for the single-line cells. It does not work on the multiple-line cells (i.e. B3, B4 and B8). I do appreciate your prompt reply.
  5. C

    Extract add numbers from alphanumeric strings in single cell w/ multiple lines

    Hello everyone, I'd love to hear your ideas on how to deal with this excel challenge I am facing. I have alphanumeric strings (Column B). The numbers outside parenthesis are quantities I'd like to add/sum up. The information in parenthesis states the type of units. Column A shows the delivery...
Back
Top