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

Remove specified string from value
 

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

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Todd Huttenstine" wrote in message
ps.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