Excel Formula to extra partial data based on a Delimiter

Hi,

I am trying to create Folder names for different project folders based using "&" function.

However one of the data in a cell has a "/" symbol included so when I copy the folder name the / symbol cannot be copied.

Below for example-

Invoice No. - FZE 8011
Reference Number - FPO-2256/2023
Client - Mechatronics Industrial Equipment L.L.C

Using a Formula The result I get is FZE 8011 - FPO-2256/2023 - Mechatronics Industrial Equipment L.L.C

The result I want is FZE 8011 - FPO-2256 - Mechatronics Industrial Equipment L.L.C.

So basically in the Reference number cell whatever comes after "/" should be removed. Please advise how I can extract or select only partial data from reference cell. Attached sheet for reference. AUMA reference cell I want to extract only the text before "/".