On 25/07/2012 22:21, isabelle wrote:
hi,

Sub Macro1()
t1 = "1969 Corvette Bumper - Chrome Retainers included - quality rating
of 10- ETA: 07/30/12."
t2 = "ETA " & Split(t1, "ETA")(1)
End Sub

Splitting on "ETA:" would be safer and forcing match case would help.

=LEFT(A1, FIND("ETA:", A1,1)-2)

Would be my choice in a worksheet functions.
Needs some work to defend against ETA not being found etc.

--
Regards,
Martin Brown