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

Can I select specific words form a group of words from one cell

A

Agil

New Member
Sir,


One cell has a free flow text with some inputs which is standard. Is there any way, I can pick only those standard words.


Example


Have posted to Street 1, on jan 2012 - I need to extract only street 1 to a different column.
 
Hi ,


Can you specify how to isolate the standard words ? Only if you detail the rules , someone can help you to implement them in Excel. One example does not suffice because no general pattern which can be decided on the basis of one example will vary from one person to another.


Narayan
 
Hi, Agil!

Nice problem, let's see if this helps you, just advise if it doesn't:

http://www.4shared.com/file/cmYgyVsL/Can_I_select_specific_words_fo.html

Regards!
 
You must log in or register to reply here.
Back
Top