Forum Discussion
Power Query - Spilt Column From Digit to Non-digit Once
Hello, I need help with Power Query for something. I have a column that has both addresses and 6-7 digits student ID at the end of each row for that column, and I need to split them out into ...
rsbin
Community Champion
Community ChampionAnonymous ,
If the ID is always 6 digits use:
=text.end( [Address & ID], 6).
Then you can Trim the address column to get rid of the last " ".
Happy Holidays.