Regex or Text to Column

[mustufa2019]

I am trying to do a text to column or Regex function to remove certain words from my fields. See below example:

Input

Name

Adam Smith

David Warner

Admin 1 Mark Donald

Admin 2 Alan Donald

Mark Jones

Admin 3 Steve Smith

Output: I would like to either remove the "Admin" from my data or have them in separate columns. I shared two output examples that would work for me.

Output 1 (remove admin completely)

Name

Adam Smith

David Warner

Mark Donald

Alan Donald

Mark Jones

Steve Smith

Output 2 (text to column)

Name	Name
	Adam Smith
	David Warner
Admin 1	Mark Donald
Admin 2	Alan Donald
	Mark Jones
Admin 3	Steve Smith

[mustufa2019]

@afv2688 Thank you so much! this worked!