Remove specified string from value

I have the following string:
"7D: test messages"

I would like to remove the value "7D: " from the string

How do I do this



Thanks

=SUBSTITUTE(A1,"7D: ","")

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Todd Huttenstine" <todd.huttenstine@verizonwireless.com> wrote in message
news:1138726731.947469.4280@z14g2000cwz.googlegroups.com...
> I have the following string:
> "7D: test messages"
>
> I would like to remove the value "7D: " from the string
>
> How do I do this
>
>
>
> Thanks
>