excel return every to 1st non alphanumeric character
Account Home | Help | Blog | Contact us | Log Out


Welcome to Kbytes > Articles

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

 

bajo/a

 

blanco/a

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

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

 

 


blog comments powered by Disqus

Kbytes Home | Privacy Policy | Contact us | Testing Area

© 2004 - 2018 1 Oak Hill Grove Surbiton Surrey KT6 6DS Phone: +44(020)82617371