I have 2 ranges of data. I have range O2:O100 which will
contain values based on data in Range P2:P100.

I need a code that will look through every value in range
P2:P100 and if it finds a % in any of the values, I need
the value of the corresponding cell in Range O2:O100 to
be "%".

If it finds just a raw number (such as 45, 140, 25,
etc...) in any of the values, I need the value of the
corresponding cell in Range O2:O100 to be "General".

Thanks in advance.

Todd