Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.
Course Of The Month
Become a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Cut to semi colan
Posted on 2013-01-04
Hi,
I have multiple names listed as:
Smith, John: Operations (LDN)
Cadogan, Denis: FI Rates (NYK)
etc
I need some formula/code that can cut each name to
Smith, John
Cadogan, Denis
Thanks!
I have multiple names listed as:
Smith, John: Operations (LDN)
Cadogan, Denis: FI Rates (NYK)
etc
I need some formula/code that can cut each name to
Smith, John
Cadogan, Denis
Thanks!
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
A little background as to how I came to I design this code:
Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210 (2 * 3 * 5 * 7) or 2310 (2 * 3 * 5 * 7 * 11).
The larger templa…
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month6 days, 9 hours left to enroll
634 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.