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 |
Solved! Go to Solution.
@afv2688 Thank you so much! this worked!