+ Reply to Thread
Results 1 to 3 of 3

Remove the symbol from column

  1. #1
    Registered User
    Join Date
    09-17-2014
    Location
    Korea
    MS-Off Ver
    2010
    Posts
    2

    Remove the symbol from column

    Hello, I've dataset like 17/Sep/2014:00:00:35. i've to remove only first : between date and time. Its mean the result have to be 17/Sep/2014 00:00:35
    i tried many methods replace find etc.

    Please help me,
    Thank you.

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Tse,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    09-17-2014
    Location
    Korea
    MS-Off Ver
    2010
    Posts
    2

    Re: Remove the symbol from column

    Thank you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Remove All Characters Past Symbol
    By jkelly228 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-25-2011, 02:00 PM
  2. remove % symbol in a cell
    By girish749 in forum Excel General
    Replies: 4
    Last Post: 01-03-2011, 03:56 AM
  3. Replies: 2
    Last Post: 07-01-2010, 06:34 PM
  4. How to Hide/Remove/Eliminate #N/A symbol
    By Locust in forum Excel General
    Replies: 9
    Last Post: 05-26-2010, 04:54 AM
  5. Remove text after an '&' symbol in a cell
    By Badvgood in forum Excel General
    Replies: 3
    Last Post: 05-13-2007, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1