(Msg. 1) Posted: Wed Nov 19, 2008 8:11 pm
Post subject: Split ASCII Archived from groups: microsoft>public>excel>setup (more info?)
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
(Msg. 2) Posted: Fri Nov 21, 2008 3:42 am
Post subject: RE: Split ASCII [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
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
> 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: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office