Excel Magic Trick 1113

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


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.


Download “Excel Magic Trick 1101-1120” Excel-Magic-Trick-1101-1120.zip – Downloaded 300 times – 2 MB

Be the first to comment

Leave a Reply