| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CSV to ASCII | Excel Discussion (Misc queries) | |||
| Split cell ascii | New Users to Excel | |||
| How do I remove split a split window? | New Users to Excel | |||
| Ascii in a cell | Excel Discussion (Misc queries) | |||
| ASCII files ...please help | Excel Discussion (Misc queries) | |||
Hybrid Mode
