Previous Topic Next Topic

Pull specific data from excel cell

Closed
CLinkFC - May 29, 2012 at 02:41 PM
Mehedad Posts 22 Registration date Thursday April 19, 2012 Status Member Last seen April 16, 2013 - May 30, 2012 at 05:56 AM
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?


Related:

1 response

Answer 1 / 1
Mehedad Posts 22 Registration date Thursday April 19, 2012 Status Member Last seen April 16, 2013 3
May 30, 2012 at 05:54 AM
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
Mehedad Posts 22 Registration date Thursday April 19, 2012 Status Member Last seen April 16, 2013 3
May 30, 2012 at 05:56 AM
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.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Excel if range of cell contain a text put a cell value in
diegomagum -
TrowaD -

11 responses