Split ASCII

D

dk

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
 
G

Gary''s Student

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Multiple Line handling with Split() 1
Split cell ascii 2
Split column contents (de-concantenate) 7
Is there any way to split contents of a cell into more cells. 2
How do I remove the last 4 characters within a cell 4
Stacked Columns with different series in each column 0
Split name, city and state 8
How to split number and text string to separate cells? 5

Top