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 |
