Cut to semi colan

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!
Seamus2626Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
barry houdiniConnect With a Mentor Commented:
That looks like a colon rather than semi-colon.....

...so try this formula in B2 assuming data in A2

=LEFT(A2,FIND(":",A2&":")-1)

If there is no colon in the cell then the formula returns the whole cell contents

regards, barry
0
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
=left(a1,find(":",a1)-1)
0
 
Seamus2626Author Commented:
Thanks guys!
0
All Courses

From novice to tech pro — start learning today.