Excel Magic Trick 1113

Extract All Characters In Cell To Separate Cells: PPPP to P, P, P, P

DESCRIPTION

1. Text To Columns using Fixed Width, One Time Event
2. Formula that will update when data changes. Formula uses MID and COLUMNS functions and Mixed Cell References.

WORKBOOKS