Extract values from cell

[Ananthak275]

I have the follow values in a cell:

Original Value	BlockChain	Retweet	BlockChain
BlockChain:xyz Retweet:abc BlockChain:adc	xyz	abc	adc

would like to use excel formula and VBA

 

[HongRu]

Try.

BlockChain.xlsx
	A	B	C	D
1		BlockChain	Retweet	BlockChain
2	BlockChain:xyz Retweet:abc BlockChain:aEc	xyz	abc	aEc
工作表1

Cell Formulas
Range	Formula
B1	B1	=LEFT(A2,FIND(":",A2)-1)
C1	C1	=MID(A2,FIND(" ",A2)+1,FIND(":",A2,FIND(" ",A2))-FIND(" ",A2)-1)
D1	D1	=MID(A2,FIND(" ",A2,FIND(" ",A2)+1)+1,FIND(":",A2,FIND(" ",A2,FIND(" ",A2)+1))-FIND(" ",A2,FIND(" ",A2)+1)-1)
B2	B2	=MID(A2,FIND(":",A2)+1,FIND(" ",A2)-FIND(":",A2)-1)
C2	C2	=MID(A2,FIND(":",A2,FIND(":",A2)+1)+1,FIND(" ",A2,FIND(" ",A2)+1)-FIND(":",A2,FIND(":",A2)+1)-1)
D2	D2	=RIGHT(A2,LEN(A2)-FIND(":",A2,FIND(":",A2,FIND(":",A2)+1)+1))

 

[hrayani]

Hello,

try

Book1
	A	B	C	D
1	Original Value	BlockChain	Retweet	BlockChain
2	BlockChain:xyz Retweet:abc BlockChain:adc	xyz	abc	adc
Sheet1

Cell Formulas
Range	Formula
B2	B2	=MID(A2,SEARCH(":",A2)+1,3)
C2	C2	=MID(A2,SEARCH(":",A2)+1+SEARCH(":",A2,SEARCH(":",A2))+1,3)
D2	D2	=MID(A2,SEARCH(":",A2,SEARCH(":",A2)+1+SEARCH(":",A2,SEARCH(":",A2))+1)+1,3)