#1
|
|||
|
|||
Extracting Skills in Paragraph Format
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 Last edited by mycon73; 07-26-2018 at 10:40 PM. |
#2
|
|||
|
|||
Maybe like the attached.
|
#3
|
|||
|
|||
Hi Xor
This works great!!! Thanks for the assistance |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Keeping the source format when extracting data from multiple cells using Vlookup function | praboos2001 | Excel | 6 | 11-15-2016 04:40 AM |
3x1 Table: text in fields loses paragraph format when being bulleted | madasco | Word | 3 | 06-07-2013 06:44 AM |
Refresh Skills | obietrice | Office | 1 | 08-01-2011 05:24 AM |
Hide paragraph format marks | Cara | Word | 2 | 04-07-2011 10:26 AM |
World Skills 2009 (Word) Day1Task2 & Day2Task1 Solution? help | cdplayerman | Word | 0 | 04-22-2010 09:08 AM |