ghdub
09-28-2015, 08:37 AM
Hello, I have just recently got into VBA and am having difficulty getting the relevant data from the below text string as the length varies.
I am looking to get the bold text from the below strings
ie 9600, 24 3150,12975 copied into column B
Can somebody suggest a formula, or alternatively a vba code to strip out the relevant numbers bolded below and copy in the data into the next column.
There is a fixed character length at the right and left of the relevant data.
COLUMN A
Basis, Klasse ("OPT, 254856, DE0008469008, 846949, 20.06.2016, 9600, C") could not be determined
Basis, Klasse ("OPT, 254857, DE0005552004, 555200, 20.06.2016, 24, C") could not be determined
Basis, Klasse ("OPT, 254892, EU0009658145, 965239, 19.10.2015, 3150, C") could not be determined
Basis, Klasse ("OPT, 254893, EU0009658145, 965239, 19.10.2015, 12975, P") could not be determined
I am looking to get the bold text from the below strings
ie 9600, 24 3150,12975 copied into column B
Can somebody suggest a formula, or alternatively a vba code to strip out the relevant numbers bolded below and copy in the data into the next column.
There is a fixed character length at the right and left of the relevant data.
COLUMN A
Basis, Klasse ("OPT, 254856, DE0008469008, 846949, 20.06.2016, 9600, C") could not be determined
Basis, Klasse ("OPT, 254857, DE0005552004, 555200, 20.06.2016, 24, C") could not be determined
Basis, Klasse ("OPT, 254892, EU0009658145, 965239, 19.10.2015, 3150, C") could not be determined
Basis, Klasse ("OPT, 254893, EU0009658145, 965239, 19.10.2015, 12975, P") could not be determined