Skip to content

P3 - v 3.1

Brian MittonMember for 18 years 7 months
Created
3
1
0
I am trying to do tabular resource loading to an excel sheet and all the info from P3 is being placed into one cell in the excel sheet, instead of separate columns.

3 replies

Oldest first
  1. 0
    Colin Blair ·
    Hi Brian

    I’m not sure this will help ....
    (depends on output format from P3)

    In Excel
    Select the cell
    Select "Data"
    Then "text to columns"
    select "delimited" - then Next
    tick space (or another option) - Then next
    Check the outcome (+ select other format)
    Finish

    Regards

    Colin
  2. 0
    Brian Mitton ·
    Colin,
    Bingo...thanks very much for your assistance, owe you a pint

    Regards

    Brian
  3. 0
    Colin Blair ·
    No problem Brian

    Thanks for the feedback

    I’ll take you up on the pint when I’m next in Ireland :)

    Colin

Log in or join to reply

ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.

Existing members: your original username and password still work. Forgot password?