Macro to split large range of text with multiple delimiters.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Unfortunately, it doesn't exactly take care of it all. For example, the data is uploaded in a huge huge huge variety of ways. The examples i gave you were very clean and exact. These are more examples:

NUT NYLOC UNC 1/2" ST/ST A4-80
NUT ST/ST M10
BZP M20 NUT, GR 8.8
LOCKNUT ST/ST M20 KOPEX
SELF CLINCHING NUT, M12 A2-70
LOCK NUT BRASS 1 1/4" BSP
M25 LOCK NUT NICKEL PLATED BRASS

The required format stays the same.

Is this something that cannot be programmed easily as they amount of variables are huge?

Again, thank you for all your help.