Previous Topic Next Topic

Pull specific data from excel cell

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

Réponse 1 / 1
Mehedad Posts 22 Registration date Thursday 19 April 2012 Status Member Last seen 16 April 2013 3
30 May 2012 à 05:54
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 19 April 2012 Status Member Last seen 16 April 2013 3
30 May 2012 à 05:56
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
Phone lock code for gt-e1200y
migs23 -
Computertech -

1 response
How to activate the Button as Activecell
adikademani -
ac3mark -

1 response