Remove specified value from string
 

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

Remove specified value from string
 

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