I have data in cells that looks like this
This is all in one cell.
I need a macro that extracts "TTD3" and "24" and puts them in separate cells.![]()
Please Login or Register to view this content.
Variations: sometimes instead of TTD3, its WS20, SM6, RTD4, GW13, RT40, or10/6RS.
Quantity can be anywhere from 15 to 468.
Here are a couple more examples
![]()
Please Login or Register to view this content.
The other data in the cell isnt needed, it can be deleted or left as long as the part number and quantity end up in different cells, so for example A1 would start with "003 000969736 082687112108 UPC SM6 12 EA 6.8800 4/3 82.56" and then B1 would contain "SM6" and C1 would contain "12"
Thank you
Bookmarks