After export activity table from Primavera P6 to Excel, it’s very hard to tell this activity belong to what WBS. We can add 1 column to show the WBS level for each activity.

The formula for the column is : =((FIND(TRIM(B2),B2))-1)/2 Apply to the rest so we can see WBS level for each activity: ## 9 thoughts on “Primavera P6 export to Excel. How to identify WBS level for activity”

1. Jigar Shah says:

Hi!

We can also add WBS Path Column, and get the details of Level and Total Path.

Thanks,

Jigar Shah

Liked by 1 person

2. Mohamed Raouf says:

I’m using similar formula : =FIND(LEFT(TRIM(K6)),K6)

Liked by 1 person

3. Khuong Do says:

Hi all,

Like

4. Andrey Lysenko says:

Hi all,

can anyone help me?
very strange..excel gives out formula issue as follow:

We found a problem with this formula. Try clicking Insert Function on the Formulas tab to fix it, or click Help for more info on common formula problems.

Not trying to type a formula?
When the first character is an equal (=) or minus (-) sign, Excel thinks it`s a formula:

you type =1+1, cell shows : 2

To get arround this, type an apostrophe (`) first:

you type: `=1+1, cell shows =1+1

Thanks

Like

5. DARE OMOPARIOLA says:

Hi all, how can i apply the formula to the rest of the tasks after the first row?

Like

1. Mohamed Raouf says:

Simply, you can drag it to the rest of rows, or copy & paste

Like

6. Mohamed Elmahdy says:

=((FIND(TRIM(B2),B2))-1)/2 why (/2) ??
and can we use =((FIND(TRIM(B2),B2))-1) only
1. Khuong Do says: