Solved

VBA Replace

Posted on 2013-11-14
4
206 Views
Last Modified: 2013-11-14
Hi,

Have this:

Call Date: 09/13/14

Dim CallDate As String
CallDate = Replace("Call Date: ", "Call Date: ", "")

I just want the 09/13/14 to be the end value and remove "Call Date: " completly
0
Comment
Question by:Computer Guy
  • 2
4 Comments
 
LVL 46

Expert Comment

by:Martin Liss
ID: 39647998
Is "Call Date: 09/13/14" in a cell? If so then if it's in A1

Range("A1").Value = Replace(Range("A1").Value, "Call Date:", "")
0
 
LVL 35

Expert Comment

by:Kimputer
ID: 39648004
You should read the hints better when typing in the function:

CallDate = Replace(CallDate, "Call Date: ", "")

Open in new window

0
 
LVL 3

Author Comment

by:Computer Guy
ID: 39648032
@Kimputer

Hi,

I tried that, but it removes the entire line of data "Call Date: 09/13/14"
0
 
LVL 35

Accepted Solution

by:
Kimputer earned 500 total points
ID: 39648078
Can you please use copy & paste for my code ? I tested it here on Excel 2007
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
If you’re thinking to yourself “That description sounds a lot like two people doing the work that one could accomplish,” you’re not alone.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question