Skip to content

Text will not wrap after Import from Excel

barnto5Member for 7 years 8 months
Created
4
3
0

Hello all,

I have successfully imported data to P6 via XL. I have some rather long "Activity Names" that refuse to wrap inside the field.

I have tried ALL "Table Row & Font" settings to no avail.

IF I copy the text into MS Word, then paste it back into the field it will wrap!

Thoughts?

4 replies

Oldest first
  1. 0
    Santosh Bhat ·

    In your Excel import file, if

    In your Excel import file, if you force a line break in a description cell, this should import into P6. Be warned though, it wil screw up any exports to xls, or reports to csv output.
  2. 0
    Zoltan Palffy ·

    here is a trick ot get it to

    here is a trick ot get it to work

    go to view table front and row

    now uncheck Keep Current Row Heights

    Check Optimize Height by row content and under that select Do not exceed and use 2 lines per row select APPLY and nothing happens 

    NOW under that click on Select height for all rows and select 22 and then click APPLY

    now Check Optimize Height by row content and under that select Do not exceed and use 2 lines per row

    next select APPLY then select OK

    this is a little work around that you can use

  3. 0
    barnto5 ·

    Thanks for taking time to

    Thanks for taking time to reply.

    I tried your method Zoltan Palffy.

    Didn't work.

  4. 0
    Santosh Bhat ·

    Go back to your original XLS

    Go back to your original XLS import file, for the activities with long descriptions, go into that particular cell, find the point where you want the line to wrap and press ALT+ENTER

    You could even build a formula that does a replace for any description over a certain length such as:

    =LEFT(B2,50)&"
    "&MID(B2,51,250)

    Where 50 is the length you want to wrap at, and press ALT+ENTER to create the linebreak.

     

    Then reimport to overwrite the existing Activity Descriptions, and use Zoltan's method to increase row heights.

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?