P6.1 WBS ID and WBS name report
Forum Sponsor
Top Posters
Nick Johnson-Pond
3 posts
sairedz25
0 posts
Ahmed Awad
2 posts
Syed Shoeb
0 posts
Vimukthi
0 posts
bal aji
2 posts
Lee Mallek
23 posts
Viet Tran
9 posts
Ola Gbotoso
0 posts
Jaturapit Multongka
1 posts
also,
using report wizard pick WBS (column: wbs code and wbs name GRoup/Sort: WBS to level 4),run then save as csv
Roozbeh,
Yes you can use left(cell,search(" ")) formula or you can just copy same data to another column and use ctrl+h (replace commmand)
For WBS code column
find what = " "* (2 spaces + *)
Replace with = (nothing or just blank)
For WBS Name
find what = *" " (* + 2 spaces)
Replace with = (nothing or just blank)
Rodel,
You are right. When pasted in excel, there two blank characters between WBS Code and WBS name.
So I used search, left, right, and len formula of excel to separate WBS code and WBS name into two different columns.
Is this the way you would do it?
Roozbeh,
No its not. Use Left Function in excel. It will takes only seconds to do that. Send me a PM with email address and I will do it for you.
Hi Rodel,
The way you explained in your post, copies WBS Code and WBS name both in the same excel column, and it takes me more time to separate them into two columns in excel.
Roozbeh,
If you need WBS Code and WBS Name organize (group & Sort) activity by WBS to level=4, If you need all levels tick Indent if not remove tick then tick Show summaries Only.
After Group & Sort highlight all data or press Ctrl+a and select Edit-> Copy or press Ctrl+c.
Open an Excel spreadsheet and select Edit-> Paste or Ctrl+v.
All data you need are transfer to Excel.
Correction: In fact the correct term is WBS Code rather than WBS ID in my previous post.