VBA Help Please (rookie issue)
"Scott Wagner" wrote in message
...
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
|