Pull specific data from excel cell

[Closed]
Report
-
Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
-
Hello,

Is there a way to pull specific data from one cell and then put that data in multiple cells following the original cell? For example, here is the data I have in a cell...how can I pull specific data from this?

Pierson, Tony rush for 3 yards to the MU43 (Wilson, Andrew).

I would like to be able to pull the following - Pierson, Tony/rush/3/Wilson, Andrew (slashes indicate separate cells).

Thanks so much in advance, and if I should be doing this in another program, could you point me in the right direction?


1 reply

Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
What is the logic/sequence of separating the words? The data will always have the same number of words?
Should it be like
1st Cell will have the first 2 Words
2nd Cell will have the 3rd Word
3rd Cell will have the Number in the text
4th Cell will have the last two Words?
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

Posts
22
Registration date
Thursday April 19, 2012
Status
Member
Last seen
April 16, 2013
3
For example, the first two words can be separated using this Formula:
=LEFT(A1,FIND(" ",A1,FIND(" ",A1,1)+1))
Considering your text is in A1.