Name Extraction

Hi guys,

i am trying to extract the names in excel from
Mr Brad Pitt / Ms Angelina Jolie to Mr and Mrs Pitt
Ms Katie Holmes / Mr Tom Cruise to Mr and Mrs Cruise

Not sure if there is a genius out there who can help!

Thanks. Ernest

Hi, This is a UDF.
I assumed you Data Names Are split by a "/".
Right click the sheet Tab.
Select "ViewCode" VB Winddow Appears.
On the VB ToolBar Select " Insert" , "Module".
New window appears. Paste the entire code into the window.
Use UDF Function as :- =Cup(Select your Cell with Data here)

Please Login or Register  to view this content.

regards Mick