Hi all! i need help in renaming the data. It might be possible to do this using the LEFT or RIGHT tool? But i havent been successful with it, please advise!
| Name |
| A1234 - Group APAC Team Finance |
| A2314 - Group APAC Team Human Resources |
| A4235 - Group EUROPE Management |
| A8237 - Group AMERICA Team Marketing |
| A8372 - Group AMERICA Business |
Desired outcome:
| Name | Desired name |
| A1234 - Group APAC Team Finance | Group APAC Team Finance (A1234) |
| A2314 - Group APAC Team Human Resources | Group APAC Team Human Resources (A2314) |
| A4235 - Group EUROPE Management | Group EUROPE Management (A4235) |
| A8237 - Group AMERICA Team Marketing | Group AMERICA Team Marketing (A8237) |
| A8372 - Group AMERICA Business | Group AMERICA Business (A8372) |
Thank you all!
