Results 1 to 12 of 12

Convert UNIX timestamps to XL and remove squares from a string of data in a column

Threaded View

symaxf Convert UNIX timestamps to XL... 02-16-2011, 05:08 PM
symaxf Re: Convert UNIX timestamps... 02-18-2011, 07:10 PM
DonkeyOte Re: Convert UNIX timestamps... 02-19-2011, 03:19 AM
symaxf Re: Convert UNIX timestamps... 02-21-2011, 01:38 AM
DonkeyOte Re: Convert UNIX timestamps... 02-21-2011, 05:08 AM
watersev Re: Convert UNIX timestamps... 02-21-2011, 08:16 AM
symaxf Re: Convert UNIX timestamps... 02-21-2011, 12:13 PM
symaxf Re: Convert UNIX timestamps... 02-21-2011, 02:16 PM
DonkeyOte Re: Convert UNIX timestamps... 02-22-2011, 03:58 AM
  1. #1
    Registered User
    Join Date
    08-19-2010
    Location
    Arizona, USA
    MS-Off Ver
    Excel Mac 2011
    Posts
    59

    Thumbs up Convert UNIX timestamps to XL and remove squares from a string of data in a column

    Hello Experts!

    I have an excel 2003 workbook with a column of data imported from UNIX that contains UNIX date/timestamps as well annoying 'squares' which represent spaces. Is there a macro or formula that can reformat this data to a more friendly/readable format (mm/dd/yyyy and replace the squares with spaces). Here is an example of what is contained in a single cell in this column (Column K):

    1294698665herambh.sharmalaApproved -- as alternate for chamner1294701745tami.fordhanApproved1294755258joe.smithApproved1294755258Application ServiceProcess Approved

    Any help would be greatly appreciated.

    S.
    Last edited by symaxf; 02-22-2011 at 07:01 PM. Reason: added prefix

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