Delete value in a string

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

I would like to remove the value "7D: " from the string

How do I do this?



Thanks

See previous post

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

in the light of other posts

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Todd Huttenstine" <todd.huttenstine@verizonwireless.com> wrote in message
news:1138726798.547656.179750@o13g2000cwo.googlegroups.com...
> I have the following string:
> "7D: test messages"
>
> I would like to remove the value "7D: " from the string
>
> How do I do this?
>
>
>
> Thanks
>

Use the =REPLACE() function:


Sub Macro1()
Dim s As String
s = "ab"
s = Replace(s, "a", "")
MsgBox (s)
End Sub
--
Gary's Student


"Todd Huttenstine" wrote:

> I have the following string:
> "7D: test messages"
>
> I would like to remove the value "7D: " from the string
>
> How do I do this?
>
>
>
> Thanks
>
>

What did you mean by

> Use the =REPLACE() function:

showing it as a worksheet function. The arguments for the Replace worksheet
function are:
=REPLACE(old_text,start_num,num_chars,new_text)

Did you mean the worksheetfunction Substitute instead or were you actually
refering to the Replace VBA function (introduced in xl2000) which you later
demo'd in your code and not intending to imply a worksheet solution at all?

Or is there a third interpretation?

Just confusing what you meant.

--
Regards,
Tom Ogilvy


"Gary''s Student" <GarysStudent@discussions.microsoft.com> wrote in message
news:017C42D9-5FB0-4E6F-A84A-714EEFDA105B@microsoft.com...
> Use the =REPLACE() function:
>
>
> Sub Macro1()
> Dim s As String
> s = "ab"
> s = Replace(s, "a", "")
> MsgBox (s)
> End Sub
> --
> Gary's Student
>
>
> "Todd Huttenstine" wrote:
>
> > I have the following string:
> > "7D: test messages"
> >
> > I would like to remove the value "7D: " from the string
> >
> > How do I do this?
> >
> >
> >
> > Thanks
> >
> >

Just select all the data and do Edit / Replace, Replace '7D: ' (No quotes)
with nothing.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------



"Todd Huttenstine" <todd.huttenstine@verizonwireless.com> wrote in message
news:1138726798.547656.179750@o13g2000cwo.googlegroups.com...
>I have the following string:
> "7D: test messages"
>
> I would like to remove the value "7D: " from the string
>
> How do I do this?
>
>
>
> Thanks
>