Home » Forums » Open Source Learning Center » Question and Answer

Separate name from text

Submitted by karunakar on 27 November, 2014 - 16:46

Hi ,

I wan to separate the name from text to another cell as Ashworth Neil for the below text

Ashworth Neil08-12-2013STD
Bell Joseph08-12-2013STD
Bin-Dory Mbarak08-12-2013STD

Please provide the formula..

Thanks

Karunakar

‹ Dele row button Excel 2010: Stock List with Archiving cell data option ›
»

Hi

Submitted by Jon on 27 November, 2014 - 21:07.

Here you go

assuming your text is in A1, paste the following formula in B1

=LEFT(A1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))-1)

Hope this helps

»

Thank you very much, it works

Submitted by karunakar on 9 December, 2014 - 12:02.

Thank you very much, it works me

»