Find Consecutive whitespace >2

[ilcaa722]

I want to just get the name of the business only, so im thinking of find the starting point when 2 or more consecutive white spaces occur then I can Text.Start length-start of consectuive white space) , but it varies... some are 5 spaces, some are 7 spaces.. or do you have a better way?

SOUTH BEACH FOOD MART #4732       01/05

ALTON ROAD LIQUORS      215487 01/07

THE HOME DEPOT     01/08 Cash Back $20.00

[BA_Pete · Accepted solution]

Hi @ilcaa722 ,

Select your column in Power Query, go to the Transform tab > Split Column (dropdown) > by Delimiter.

Enter double-space as a custom delimiter then select to only split at the left-most delimiter:

Pete