ExcelBanter - Split ASCII

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Split ASCII (https://www.excelbanter.com/setting-up-configuration-excel/211019-split-ascii.html)

Split ASCII

Is there any way to split cells of a complete column by ASCII/numeric
ex:dav123
Shall be split at dav 123
there may be identical number of characters in a cell or different
please reply ASAP
Thank You

Gary''s Student

Split ASCII

Say A1 contains:
dav123

In C1:
=MID(LEFT(A1,FIND(",",A1&",")-1),MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0123456789") ),255) displays 123

In B1:
=LEFT(A1,LEN(A1)-LEN(C1)) displays dav
--
Gary''s Student - gsnu200815 gsnuxx

"dk" wrote:

Is there any way to split cells of a complete column by ASCII/numeric
ex:dav123
Shall be split at dav 123
there may be identical number of characters in a cell or different
please reply ASAP
Thank You

All times are GMT +1. The time now is 01:49 AM.