Hi all,
I have two sheets. One containing in cell B2 "1211 - Extra Core Hours" (t_Cost_Centre_data) and then another sheet that displays the data. On the display sheet, there need to be two fields. Event ID and Event Name. The event ID is the "1211" and the name "Extra Core Hours".
My question is, how do I split the reference so that only the ID and name appear in the relevant cell?
Ie Event ID Event Name
1211 Extra Core Hours
Note, the ID's and names will change and they will be multiple.
Thanks!
Example file linked below
Formula Help!.xlsx
Bookmarks