+ Reply to Thread
Results 1 to 3 of 3

Extract date format

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Extract date format

    hello expert..

    i am looking formula to extract data date format with result (e.g.10 Januari 2004,23 Desember 1998, etc...)

    for example :

    Bangkok, 21 Agustus 2005 -------------- 21 Agustus 2005
    Jakarta,10 Mei 2002 -------------------- 10 Mei 2002
    Pekanbaru,05 Juli 1997 ------------------ 05 Juli 1997

    Thanks in advance....

    JOHN.M

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,463

    Re: Extract date format

    Try Data - Text to columns and use the comma as delimiter.
    In the wizard's last window select to "not import" the first column

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Extract date format

    Thanks, pepe...

    I missing it....

+ 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. [SOLVED] extract date format sheet names into range vba
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-03-2014, 10:16 AM
  2. [SOLVED] Extract numbers from date to number format
    By Jonathan9 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-21-2013, 09:33 AM
  3. Using right, find functions to extract text and keep the format in "date"
    By iceordo in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-15-2012, 05:40 PM
  4. Replies: 2
    Last Post: 01-17-2010, 10:39 AM
  5. Date - Time Format, How to Extract Month
    By longfisher in forum Excel General
    Replies: 4
    Last Post: 06-06-2007, 10:35 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