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 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)
regards Mick![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks