• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

VBA Replace

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
Computer Guy
Asked:
Computer Guy
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
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
 
KimputerCommented:
You should read the hints better when typing in the function:

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

Open in new window

0
 
Computer GuyAuthor Commented:
@Kimputer

Hi,

I tried that, but it removes the entire line of data "Call Date: 09/13/14"
0
 
KimputerCommented:
Can you please use copy & paste for my code ? I tested it here on Excel 2007
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now