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

    Extracting Whole Address to Multiple Cells

    Hui Thank you very much...works like a charm and your help saved me a lot of work. Much appreciation for this board and the contributors.
  2. W

    Extracting Whole Address to Multiple Cells

    @ TessaES - thank you for the "duh" moment with using text to columns. It's a great suggestion. @ Myles - thank you for the suggestion as well. I know how to use the Left, Right & Mid formulas but only in the most simplistic way. I'm in need of more study to better grasp the way Hui used them...
  3. W

    Extracting Whole Address to Multiple Cells

    Wow...what a great response. Thank you so much everyone. I am not sure how to load a file up so if I did it incorrectly please accept my apologies. @ Hui - I took your suggestions and added the formulas to populate the results but there seams to be a few issues within the address and state...
  4. W

    Extracting Whole Address to Multiple Cells

    Darn if I cannot figure this out. I kindly ask for this forums collective "guru" knowhow. I use the =left and =right formula all the time but only for easy extractions nothing overly complex. I run many queries which report back the entire stores address within one cell. Is there a formula I can...
Back
Top