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

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







Be the first to comment

Leave a Reply