Results 1 to 3 of 3

Remove partial text from cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2014
    Location
    Singapore
    MS-Off Ver
    Excel for Mac 2011 Ver 14.3.9
    Posts
    4

    Remove partial text from cell

    I am copying text and posting into excel. As it is formatted on the original site, it posts the date, followed by time.
    example: 26/5/14 20:16 (Please refer to screen shot. The text in the cell is shown as 26/5/14 20:16, the actual value is 26/5/2014 8:16:20 pm).

    I need to have the dates removed.
    Example: 21:18

    I've found some similar cases in other thread and the answer seems to be something like this =SUBSTITUTE(LEFT(A6,SEARCH("-",A6)-1),".","")
    I can't seems to get it work. Im not sure where have I gone wrong. I would greatly appreciate advice from you.

    Or should I be looking for a different method?

    (It is not an option to have the original web site change their posted format).
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] remove partial text from cell
    By D Casten in forum Excel General
    Replies: 6
    Last Post: 07-13-2014, 11:11 PM
  2. Remove partial text from 1 column?
    By IsabellaLearning in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-03-2014, 04:06 AM
  3. remove duplicates based on partial text match
    By smelkin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-16-2011, 09:45 AM
  4. matching partial text within one cell to partial text within another
    By Solstice in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 03-03-2010, 09:13 PM
  5. Remove partial text from drop down list
    By excel1969 in forum Excel General
    Replies: 6
    Last Post: 10-12-2009, 05:00 AM

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