Solved

VBA Replace

Posted on 2013-11-14
4
175 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 45

Expert Comment

by:Martin Liss
Comment Utility
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
Comment Utility
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
Comment Utility
@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
Comment Utility
Can you please use copy & paste for my code ? I tested it here on Excel 2007
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Whether you’re a college noob or a soon-to-be pro, these tips are sure to help you in your journey to becoming a programming ninja and stand out from the crowd.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

762 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now