Results 1 to 13 of 13

How to delete first character in cells and generate graphs from new column

Threaded View

  1. #1
    Registered User
    Join Date
    10-25-2012
    Location
    Baton Rouge
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to delete first character in cells and generate graphs from new column

    Hello to all

    My issue is relate to a database query application that export the data in a format that I had been unable to use to generate graphs or pivot table or graphs. It a turnaround query and looks like is exported as d hh:mm but when exporte to excel I can't custom the format or delete the nitial 3 character with formulas as : =RIGHT(Xx,LEN(Xx)-3) because them I can't use the result cell in graphs or pivots.
    I'll like to know if there is another formula or macro that can help me to convert those columns in a excel valid format.

    I'm attaching a screenshot with an example of the problem where the top table represent the original data afetr exported from the application and the botton table is how I'll like to see in order to generate pivot or graph.

    Thanks fro any help...
    Felipe
    7t4d.jpg
    http://img153.imageshack.us/img153/6955/7t4d.jpg
    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] Delete row macro based on a specific character in the FIRST postion of a specified column
    By slawless in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-21-2012, 07:38 AM
  2. Delete rows if cells have character(s)...
    By elsoung in forum Excel General
    Replies: 8
    Last Post: 10-04-2012, 06:29 PM
  3. Macro to delete a specific character and capitalizing a column
    By abuchan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-06-2011, 11:54 PM
  4. generate graphs for each row
    By rejoice in forum Excel General
    Replies: 1
    Last Post: 04-19-2008, 06:23 AM
  5. Replies: 7
    Last Post: 09-01-2007, 04:29 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