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

Extracting Only text and numbers from a cell

AAP

Member
Hi Friends,

I need help to extract text and numbers from cells. I am uploading a workbook showing what kind of raw data I normally get and what results I am expecting after extraction. Thanks for help in advance.
 

Attachments

  • Test Doc.xlsx
    9 KB · Views: 7
Hmm, you are not just extracting but replacing some char.
This won't be quick and easy, as you will need to build your list and/or logic first on what characters to replace and what chars to omit etc.

See if this thread helps you.
http://chandoo.org/forum/threads/how-to-find-non-ascii-characters-in-email.25389/#post-152021

Also, to extract number portion only, follow link. Both links on post#2 will work.
http://www.mrexcel.com/forum/excel-questions/443983-extract-only-numbers-text-string.html
 
Back
Top