Regex tool I think

[hi2019]

Help!

Column Payee

Johnny R Miles 3

I need the space and any # after to be removed at the end or does it have to be like specific to remove #3?

thanks

[binu_acs]

@hi2019 what is the expected output? 

[hi2019]

Johnny R Miles

without the # and without that extra space

[binu_acs]

@hi2019 I dont see any input is given, i created one for the solution

[hi2019]

I want the output to be just be the person name- NO #, 3, 4, 2, etc

only the persons name

I think that just removed #?

And remove any space after the # is removed

[hi2019]

Johnny R Miles 3

how to remove the 3 and any space after

and can it be for ANY number after?

[binu_acs]

[Raj]

@hi2019 
you can use the data cleansing tool as well to remove all the numbers, punctions and duplicate spaces.