Remove specified value from string

[Todd Huttenstine]

Hey

I have the following value:
"7D: Test Note"

I would like to remove the "7D: " from the above string.
How do I do this?


Thanks
Todd

[Toppers]

Todd,
With string in A1 put this in (say) b1:

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

Or in VBA, use REPLACE function

newstring=Replace(Range("A1"),"7D:","")

Range("a1") could be replaced by string variable.

HTH

"Todd Huttenstine" wrote:

> Hey
>
> I have the following value:
> "7D: Test Note"
>
> I would like to remove the "7D: " from the above string.
> How do I do this?
>
>
> Thanks
> Todd
>
>