Split text from data with number

[KIM Chanthan]

Hi,

Do you have any easy excel formula to split text from a combination of letter and number.
Please see attached for more detail.

Thanks,

 

[Marc L]

Hi !

B2 formula : =LEFT(A2,SEARCH("0",A2)-1)
Copy down …
​

 

[bosco_yip]

Further to Marc's proposal, if the 1st digit not always 0, try this in B2 and copied down:

=LEFT(A2,MIN(FIND({0,1,2,3,4}+{0;5},A2&1/17))-1)

Regards
Bosco

 

[KIM Chanthan]

Hi !

B2 formula : =LEFT(A2,SEARCH("0",A2)-1)
Copy down …
​

Thanks, it's very simple and easy

 

[KIM Chanthan]

Further to Marc's proposal, if the 1st digit not always 0, try this in B2 and copied down:

=LEFT(A2,MIN(FIND({0,1,2,3,4}+{0;5},A2&1/17))-1)

Regards
Bosco

Thanks alot for this. It works very well

 

[rahulshewale1]

Hii @KIM Chanthan ,

Flash fill is powerful feature in excel 2013 or above.

https://www.myexcelonline.com/blog/use-flash-fill-excel/


Regard
Rahul shewale