Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

VBA Replace

Posted on 2013-11-14
4
Medium Priority
?
236 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 50

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 37

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 37

Accepted Solution

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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Question has a verified solution.

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

What do responsible coders do? They don't take detrimental shortcuts. They do take reasonable security precautions, create important automation, implement sufficient logging, fix things they break, and care about users.
Q&A with Course Creator, Mark Lassoff, on the importance of HTML5 in the career of a modern-day developer.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
Six Sigma Control Plans

578 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