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
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
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
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks