Text to columns in Excel with multiple spaces (formula splitting)

Опубликовано: 30 Сентябрь 2024
на канале: AuditExcel Advanced Excel and Financial Model Training and Consulting

5,759

00:00 Text to columns on only select rows with space as delimiter (where there are lots of unrelated spaces)
00:18 Why Text to Column tool doesn't work in this case
01:10 Which are the rows that we are actually interested in (FIND/ SEARCH function)
03:00 Determine where the last space is (to see where the amount is)
04:55 Extract the amount from the row

How to extract key information from a row where the delimiter is a space, but spaces elsewhere mean that depending on the contents of the row the number of spaces will be different and not all of them should be considered delimiters (so you can't use the Text to Column tool)