Copy from Column F

[tpkelley_no]

What would be the best formula to do the following?

The following is kept in column “F”:

18 AFL Popup AFLAC INC @ $57.4936



I would the “18” to copy in column “C” same row (This is qty). the stock symbol “AFL” in Colum “D” , and price “$57.4936” in Colum “E”. I want the end results to look like this.

C D E

qty	Symble	Cost
18	AFL	57.4936

 

[Michael M]

Maybe this...

Book1
	C	D	E
2	qty	Symble	Cost
3	18	AFL	$57.4936
Sheet1

Cell Formulas
Range	Formula
C3	C3	=LEFT(F3,FIND(" ",F3,1))
D3	D3	=MID(F3,FIND(" ",F3)+1,FIND(" ",F3,FIND(" ",F3)+1)-FIND(" ",F3))
E3	E3	=TRIM(RIGHT(SUBSTITUTE(F3," ",REPT(" ",LEN(F3))),LEN(F3)))

 

[Zot]

Only one sample data. Try this

Book1
	C	D	E	F
1	qty	Symble	Cost
2	18	AFL	57.4936	18 AFL Popup AFLAC INC @ $57.4936
Sheet1

Cell Formulas
Range	Formula
C2	C2	=LEFT(F2,FIND(" ",F2,1))
D2	D2	=TRIM(MID(SUBSTITUTE(F2," ",REPT(" ",LEN(F2))), LEN(F2)+1, LEN(F2)))
E2	E2	=TRIM(RIGHT(SUBSTITUTE(F2,"$",REPT(" ",LEN(F2))),LEN(F2)))

 

[tpkelley_no]

thank you!

 

[Michael M]

Hope it helped...