Extracting Text from a string in a Cell (Excel VBA)

[jimmynora]

I have a range of cells that contains data in the form on strings. I need to extract a part of this string and paste it (to the empty cell on the right).

Range "AV" contains the cells with strings
I need to extract the data between "0" OR "0:" and till the end of the string in the cell OR till "1"

Can anyone show me how to do this with a Macro (VBA code) or anyway else ? Thank You

example :

(String in a cell)

shawn012k
0: james
pdf: 321
1:
pdf:
2:
pdf:

Extracted Data (pasted in the cell to the right): james
pdf: 321

 

[DonkeyOte]

jimmynora, I would suggest an approach along the lines of:

Excel Workbook
	A	B	C
1	1shawn012k 0: jamespdf: 3211:pdf: 2: pdf:	jamespdf: 321	1
2	shawn012k 0: james ajskajskjaksj kajsaksjaksjakjsa pdf: 321asklakslalskl1:pdf:	james ajskajskjaksj kajsaksjaksjakjsa pdf: 321asklakslalskl	1
3	askajskajsak	askajskajsak	1
4	user bio1:0: asdasdas1: asdasds2:3: asdas	asdasds	2
Sheet1