Extract numbers from text into multiple columns

[Rick Rothstein]

[QUOTE=Giraffe;9547]Thanks Rick for trying but assuming I have entered it correctly and run it correctly it came out as attached. At the momen

Thanks Rick for trying but assuming I have entered it correctly and run it correctly it came out as attached.

The reason the code did not work for you is because I designed it for this (which came from the workbook you attached to Message #4)...

	A	B	C	D	E	F
1	100mic Gloss Film 1000mm x 100m on 78mm core	FP22GLO100001003K	22	1000	100	3
2	100mic Gloss Film 1400mm x 1400m x 78mm core	FP22GLO140014003F	22	1400	1400	3
3	125mic Gloss Film 230mm x 60m on 58mm core	FP23GLO023000602	23	230	60	2
4	125mic Gloss Film 230mm x 100m on 58mm core	FP23GLO023001002OUT	23	230	100	2
5	75mic Ultra Matt Film 110mm x 1000m on 78mm core	FR12MAT011010003	12	110	1000	3

but this is from the workbook you attached to Message #9 which you say my code did not work for...

	A	B	C	D	E	F
1	UBG315X500X77	ULTRABOND GLOSS 315mm 500m 77mm core	315	77	77	7
2	UBG315X500X77	ULTRABOND GLOSS 315mm 500m 77mm core	315	77	77	7
3	UBM315X500X77	ULTRABOND MATT 315mm 500m 77mm core	315	77	77	7

Does anything look different about those two layouts to you? Because they sure look different to me!

Now, what does your data layout actually look like... the first or second table above?

[Giraffe]

It looks like both the first and the second spreadsheet unfortunately. but the second spreadsheet is a full example of the data which should include the data from the first list? The codes (column A) should be consistent but the descriptions (column B) can be changed by the staff, even though they are not supposed to! In spreadsheet 1 I swapped the description and code columns around and forgot i had done so! Sorry!!

[Rick Rothstein]

It looks like both the first and the second spreadsheet unfortunately. but the second spreadsheet is a full example of the data which should include the data from the first list? The codes (column A) should be consistent but the descriptions (column B) can be changed by the staff, even though they are not supposed to! In spreadsheet 1 I swapped the description and code columns around and forgot i had done so! Sorry!!

So are you saying the bottom table in Message #10 is your actual layout? If so, where do the numbers in Column F come from? If you say the last digit (which is how it is in the top table), then where did the number in Column E come from?