Thought I had this figured out, but I am scratching my head...

I have three columns that have a mixture of information in them, and I need
to offset certain types of information. The issue I am dealing with is that
sometimes my 2nd column contains quantity, sometimes contains markings, and
other times contains a part number. Good news is that each is formatted
consistantly based on what type of information it is.

Quantity is of course always a number
Markings are always in bold text
Part numbers are always begin with all caps

Here is an example of what I have now:

ColA ColB ColC ColD
1 Panel
HP <--bold text
AB123

Here is what I need to end up with:

ColA ColB ColC ColD
1 Panel HP <--bold text
1 AB123 HP <--bold text

Any help you can provide would be greatly appreciated.

Thanks,

Scott