Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Splitting and removing text from a column

I have a column with some data that I want to remove.  Some rows have data that looks like this:   Tech Name 123456 - Mike Smith, 587985 - John Doe, 133455 - Jane Doe, 459832 - Jonny Five   Not ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Create a custom column

Text.Select([Tech Name],{"a".."z","A".."Z",","," "})

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.