- Joined
- Nov 9, 2023
- Messages
- 291
- Reaction score
- 768
- Location
- www.markdodge.net
- Current Ride
- 2024 1500 Bighorn
- Current Ride #2
- 2009 Mini Cooper M/T
OK gang this is a side project here that IS RHO RELATED I promise LOL.
Who among ye can help here: Need to separate the options listed in a single cell into their OWN cells
On these cells we have a list of vehicle options, separated by a comma. The option codes are all three characters each, aside from the first series which is the seat selection which is always 7 characters (*style,-color)
The problem is that the quantity of three-digit options varies from one build to the next.
Is there an easier way than just running a series of =mid(A1,9,3) type equations over and over? With the 9 replaced by 13, then 17, then 21, for example - and then at the end there may just be some errors?
Who among ye can help here: Need to separate the options listed in a single cell into their OWN cells
| *GJ,-X9,A77,DFR,DMH,DSA,EZL,JAN,MWH,NAS,NFF,PW7,WRB,XFH,XHC,27H,4EA |
| *D6,-X7,DFY,ECX,MDA,NAS,PXJ,27H,4EA |
| *DZ,-X9,AY1,DFE,ESD,GWA,MES,NAE,NEP,PFB,XS9,YCF,23B,4AK,4EA |
On these cells we have a list of vehicle options, separated by a comma. The option codes are all three characters each, aside from the first series which is the seat selection which is always 7 characters (*style,-color)
The problem is that the quantity of three-digit options varies from one build to the next.
Is there an easier way than just running a series of =mid(A1,9,3) type equations over and over? With the 9 replaced by 13, then 17, then 21, for example - and then at the end there may just be some errors?
