+ Reply to Thread
Results 1 to 2 of 2

Delete date/time in all rows from a text

  1. #1
    Registered User
    Join Date
    10-25-2004
    Location
    Massachusetts USA
    MS-Off Ver
    Microsoft 365 for Enterprise (Excel Version 2302)
    Posts
    72

    Delete date/time in all rows from a text

    Need help to delete only the date and time in a text from all rows.. For eg:

    ____________________________
    Col A

    05/09/05 09:33:01 I will come to meet you.
    05/24/05 20:38:59 lkajfsldkjfalskdjfklajsdfa;sd;fla
    04/08/05 15:26:20 wquerjsdfkja;skjkpasjfasd
    ____________________________

    Likewise the text continues in each row, through out the document. I want to delete the date and time and retain only the text in each row.

    Pls help on how to do it.

    Thanks a lot.

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by ramsdesk
    Need help to delete only the date and time in a text from all rows.. For eg:

    ____________________________
    Col A

    05/09/05 09:33:01 I will come to meet you.
    05/24/05 20:38:59 lkajfsldkjfalskdjfklajsdfa;sd;fla
    04/08/05 15:26:20 wquerjsdfkja;skjkpasjfasd
    ____________________________

    Likewise the text continues in each row, through out the document. I want to delete the date and time and retain only the text in each row.

    Pls help on how to do it.

    Thanks a lot.
    Hi

    Try this

    =MID(A1,19,100)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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