Hi all excel world,
I am a long time Excel user and forum reader and this is my first question/post for some help and assistance.
I have a data set that is in a single column and I am trying to break it out into multiple columns based on certain criteria. And I understand that this may not be possible so I'm reaching out here.
I was trying to do it based on an =LEFT( or =RIGHT( but I have been unsuccessful in getting the columns in the right order.
I was wondering (and hoping) to be able to find a way to break column A down into columns B, C, D, E, F (maybe using a word match in a macro or VB script or a probably complicated IF statement?)
Where
DATASET Device Storage Color Network Model iPhone 5 16GB white - T-Mo - ME487LL/A iPhone 5 16GB white T-MO ME487LL/A PG58100 Sensation 4G Sensation 4G PG58100 PC10100 G2 titanium G2 titanium PC10100 SGH-T999 Galaxy S 3 16GB white Galaxy S 3 16GB white SGH-T999 SM-G900T Galaxy S5 16GB black Galaxy S5 16GB black SM-G900T SGH-T889 Galaxy Note 2 16GB titanium Galaxy Note 2 16GB titanium SGH-T889
Some other examples are:
iPhone 5 16GB white - T-Mo - ME487LL/A
iPhone 5s 16GB Gold - T-Mo - ME325LL/A
iPhone 5s 64GB Silver - T-Mo - ME330LL/A
PG58100 Sensation 4G
PC10100 G2 titanium
0P6B700 One M8 gold - Sprint
D801 G2 white
D801 G2 black
D415 Optimus L90 grey
SGH-T999 Galaxy S 3 16GB white
SM-G900T Galaxy S5 16GB black
SGH-M919 Galaxy S 4 16GB white
SGH-T889 Galaxy Note 2 16GB titanium
SGH-T989 Galaxy S 2 white
Thank you for reading this and for any assistance and help.
Bookmarks