Comparing Names to string of text

May 3, 2014 at 00:16:57
Specs: Windows 8
I have a list of names i.e. John Smith Jones and have copied in a conversation from face book with names and comments. I am looking for a solution in excel 2007 that would find the names in the text and make me a list of the people that have commented. I would be very grateful of any help you could give me please.

See More: Comparing Names to string of text

Report •


#1
May 3, 2014 at 04:53:11
It would help if we knew something about how the data is laid out.

Are the names in the conversation data in their own cells or are they mixed in with other text?

If they are in their own cells, are they all in the same column? If so, which column?

The more detail you can provide related to the lay out of the data, the easier it will be for us to suggest a solution.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

#2
May 3, 2014 at 09:23:54
I have a list of the names and have to find them within mixed text

Report •

#3
May 3, 2014 at 09:38:48

If they are in their own cells, are they all in the same column? If so, which column?

The more detail you can provide related to the lay out of the data, the easier it will be for us to suggest a solution.

Post a small sample of your data.
For help on posting your data see this How-To:

http://www.computing.net/howtos/sho...

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
May 4, 2014 at 00:02:20
My list of names are in Colunm B and the text that I want to search through is in Column A from A1 to A400

Report •

#5
May 4, 2014 at 07:03:50
Does the text in Column A begin with the name you are searching for, e.g.

                 A
1   Bobby G. wrote: My car is blue.
2   Ann W. wrote: My car is is red.

Mike suggested that you post an example of your data. What you are asking for might be quite simple or it could be extremely complicated. Since we can't see your spreadsheet from where we're sitting, it would really help us help you if we knew what your data looked like. If you would remove any confidential information and post a couple of examples of the data that needs to be searched, we wouldn't have to guess at the problem we are trying to solve.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •

Ask Question