Formula in B2
=LEFT(A2, FIND(" ",A2)+1)&" "&
RIGHT(A2,LEN(A2)-FIND("-",A2)+1)
Sample Output
|--------------------------------------------------------|--------------------------|
1 | INPUT | OUTPUT |
|--------------------------------------------------------|--------------------------|
2 | Alex Hill will be 1 day on a leave - Holidays | Alex H - Holidays |
|--------------------------------------------------------|--------------------------|
3 | Anna Low will be 273 days on a leave - Maternity leave | Anna L - Maternity leave |
|--------------------------------------------------------|--------------------------|
4 | Frank Tibbs will be 2 days on a leave - Holidays | Frank T - Holidays |
|--------------------------------------------------------|--------------------------|
5 | Matthew Small will be 4 days on a leave - Holidays | Matthew S - Holidays |
|--------------------------------------------------------|--------------------------|
6 | Simon Wright will be 5 days on a leave - Holidays | Simon W - Holidays |
|--------------------------------------------------------|--------------------------|