View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ken Wright Ken Wright is offline
external usenet poster
 
Posts: 634
Default Delete value in a string

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