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?


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

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
If cell A1 has text then cell B2 has today's Date
Sasha -
ac3mark -

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

26 responses