Split text to columns using LAST delimiter only in Get & Transform

Опубликовано: 11 Февраль 2025
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting

1,757

00:00 Text to columns based on the last delimiter only in Get & Transform
00:10 Load the list with file paths into Get & Transform
00:20 Split columns by delimiter (/ in this case but could be spaces)
00:33 NB NB Use the last delimiter ONLY (furthest on the right)
00:50 Handling rows that don't have the delimiter at all

Using Excel's Get & Transform tool to split text into columns, but NOT at every delimiter (space, comma or whatever else shows where the separate columns should be) but only at the last delimiter in the row (furthest to the right). There is also the option for splitting the columns based on the FIRST delimiter only (closest to the left).