• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. M

    Formating Issue

    I had to create a few VLook ups to format dates in an excel sheet. The dates need to look like this 20100805 for Aug 8, 2010. I got that part right. I need that number to come over in a to look something like this 20100805T1500 CONCATENATE(YEAR(F2),MONTH(F2),DAY(F2),"T","1500" The problem...
  2. M

    Can Excel Do this?

    Ok I was able to figure out how to format data into a sheet now I was wondering how I can get the data into this type of format. When someone pasts into my sheet a consitantly formated data set. I have a sheet that will format the data into the Columns DTSTART DTEND DESCRIPTION...
  3. M

    Excel Template to Format data from one worksheet to another

    I need to create a Template that will allow users to paste a certain report in worksheet 2 then in Worksheet 1 it populates just certain data from Worksheet 2. Example the report has 30 columns of Data. We only want to look at 7 data points I named worksheet 2 'Paste Data Here' I used the...
Back
Top