Hi,

I have the following block of skills in a single cell


Project Engineering Management • Scheduler / Planner • Budget, Cost, Critical & Vendor Analysis • Capital Expenditures (CAPEX) • MS Project • Scope, Schedules & Budget Forecasting • Leadership, Train, Coach, Mentor • Advanced Excel • Disaster Relief • Change Management • Continuous Improvement • Value Stream Workflows • Process Improvements • Product Development • Dynamic Object Oriented Systems (DOORS) • Risk Management • Logistics Warehouse Inventory Management System (IMS) • Transportation Management • Supply Chain, ERP, SharePoint • Tollgates • Milestones • Technical Procedures • CAD Management • Product Lifecycle Management • Value Engineering • Product Data Management • Front End Engineering Design (FEED) • And Others as Needed


I'm looking to break this up per skill or bullet into a single column & multiple rows for sorting

This function kind of works but not extracting some correctly or fully

="• "&TRIM(MID(SUBSTITUTE("•"&B$4,"•",REPT(" ",100)),ROWS($1:1)*100,100))


How to get this working for all? See attached example file


Thanks

Attached Files

Extracting Skills in Paragraph Format-v2.xlsx (9.9 KB, 9 views)