parse the string

[TGeorge2]

HAVE NEED1 NEED2 111110: Soybean Farming 111110 Soybean Farming

111130: Dry Pea and Bean Farming 111130 Dry Pea and Bean Farming

111140: Wheat Farming 111140 Wheat Farming

<tbody>
</tbody><colgroup><col></colgroup>

 

[Snakehips]

TGeorge2,

If I understand your need correctly then here is one of several ways you can split the string in A

Excel 2007
	A	B	C
1	Have	Need1	Need2
2	111110: Soybean Farming	111110	Soybean Farming
3	111130: Dry Pea and Bean Farming	111130	Dry Pea and Bean Farming
Sheet3

Cell Formulas
Range	Formula
B2	=LEFT(A2,FIND(":",A2)-1)
C2	=SUBSTITUTE(A2,B2&": ","")

Hope that helps.

 

[Snakehips]

An alternative in C2 so as to be independent of B2 would be =RIGHT(A2,LEN(A2)-FIND(":",A2)-1)

 

[bigmyk2k]

That should work, additionally, could use the "Text to Columns" feature, with the colon as delimiter.

 

[DRSteele]

You could have been clear about your objective. From what you scribbled for us, I think this is what you're after:

Excel 2012
	A	B	C
1	111110: Soybean Farming	111110	Soybean Farming
2	111130: Dry Pea and Bean Farming	111130	Dry Pea and Bean Farming
3	111140: Wheat Farming	111140	Wheat Farming
Sheet34

Cell Formulas
Range	Formula
B1	=REPLACE(A1,SEARCH(":",A1,1),LEN(A1),"")
B2	=REPLACE(A2,SEARCH(":",A2,1),LEN(A2),"")
B3	=REPLACE(A3,SEARCH(":",A3,1),LEN(A3),"")
C1	=REPLACE(A1,1,SEARCH(":",A1,1)+1,"")
C2	=REPLACE(A2,1,SEARCH(":",A2,1)+1,"")
C3	=REPLACE(A3,1,SEARCH(":",A3,1)+1,"")