Account Home | Help | Blog | Contact us | Log Out

excel return every to 1st non alphanumeric character

Posted By: siteadmin on 27/01/2012 14:56:00

In excel to return every to 1st non alphanumeric character

Say you have some cells that contain things like

And you want to return just the left part then you can use this formula:

=LEFT(b1,FIND("/",b1,1)-1)