12-05-2016
01:32 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
12-05-2016
01:32 PM
Hi,
You could use split to do it, but the number of parts must be the same - in your case below it would be 5.
If you can count the number of spaces, i'm sure you could modify it so it works if the number is different.
Anyway it goes like this..
MatSplit = Split(MaterialName, " ")
For i = 0 To UBound(MatSplit)
Part1 = MatSplit(0)
Part2 = MatSplit(1)
Part3 = MatSplit(2)
Part4 = MatSplit(3)
Part5 = MatSplit(4)
Next
I hope that helps you.
Dean.