Thanks T. Valko for the array formulas. They worked perfectly!

Now I have another question. How do I use conditional formatting to
highlight all cells that contain "S" in yellow and "V" in purple, if the
cells have both text and numbers?

Here's what I want to do:

A1: S=8.0
A2: (blank)
A3: V=10.0
A4: S=4.0

Based on the cells listed above, how do I use conditional formatting to do
the following?

Results:
A1 and A4: highlighted in YELLOW
A3: highlighted in PURPLE

Thanks in advance!