Remove specified value from string
 

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

Remove specified value from string
 

one way if your example is in B2

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

--


Gary


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

Remove specified value from string
 

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

--


Gary


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