Create an automatic outline that indents the level of the task in a work breakdown structure (WBS) in Excel.
Here's the formula used in the video:
=REPT(" ",LEN(A4)-LEN(SUBSTITUTE(A4,".","")))&A4&". "&B4
Other relevant videos:
SUBSTITUTE Function: https://youtu.be/kUDOA7CyHQ0
Combining Texts: https://www.youtube.com/watch?v=OA0FU3nwxr4&t=40s
Download
0 formats
No download links available.
Create WBS Work Breakdown Structure Template in Excel | NatokHD