Remove specified value from string

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Todd Huttenstine - 31 Jan 2006 16:31 GMT

I didnt see this post the 1st time I sent so sorry if this is a
duplicate.

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

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

Thanks
Todd

Reply to this Message

Gary Keramidas - 31 Jan 2006 16:34 GMT

one way if your example is in B2

=RIGHT(B2,LEN(B2)-FIND(":",B2,1)-1)

Signature

Gary

>I didnt see this post the 1st time I sent so sorry if this is a
> duplicate.
[quoted text clipped - 7 lines]
> Thanks
> Todd

Reply to this Message

Gary Keramidas - 31 Jan 2006 16:48 GMT

here's a code solution that may work for you

Option Explicit
Dim arr As Variant
Dim s As String

Sub test()
s = Range("b2").Value
On Error Resume Next
arr = Split(s, ":")
Range("c5").Value = Trim(arr(1))
End Sub

Signature

Gary

>I didnt see this post the 1st time I sent so sorry if this is a
> duplicate.
[quoted text clipped - 7 lines]
> Thanks
> Todd

Reply to this Message