Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts

    Excel 2010 Find Question

    When I export tasks from MS Project 2010 to Excel, MSP creates all fields as text including dates, numbers, per cents, etc. And they do that with some leading character that I can not see in the cell - but I can delete. Since the spreadsheet has hundreds of rows and several columns with data I need to reformat, I can not manually delete this character from every cell.

    My question is: is there some Find function in Excel that would allow for a mass Find and Replace. MS Word Find allows for searching on special characters but Excel seems very rudimentary. I can search for text but not special characters.

  2. #2
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Possibly a combination of the Functions =CODE(cell) and =CHAR(cell) will give the character in question.
    Then use Find and Replace.

    Can you post a sample sheet with some of the cells in question?

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts
    I attached a small section of a test export
    Attached Files Attached Files

  4. #4
    5 Star Lounger
    Join Date
    Dec 2009
    Location
    East Coast, USA
    Posts
    993
    Thanks
    8
    Thanked 43 Times in 43 Posts
    Exporting from MSP to Excel can present challenges. Deciding the file format to save to is among the issues. Should the MSP be saved as .xls, .xlsx , .html, etc.etc?

    Using your attached file, try using the Function =VALUE(cell) and format each as necessary. That will convert the text to Values. Should be a fairly simple copy and paste for the rest of the data.

    See attached file in columns F thru H. Your columns A thru C can be hidden.

    Hope that helps!!
    Attached Files Attached Files

  5. #5
    2 Star Lounger
    Join Date
    Apr 2001
    Posts
    122
    Thanks
    7
    Thanked 0 Times in 0 Posts
    Thank you, using the Value Function seems to accomplish what I need to get the data into a useable format

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •