If there's not an ampersand, I want cell to be empty - it gives me #VALUE! instead

Hey all,

This is pretty much complete. The only issue I'm having is that if there's not ampersand, then just make the cell empty. Rather, it gives me VALUE error:

Please Login or Register  to view this content.

It doesn't like "" for some reason. Any other way to make the cell empty?

For example, this is what column A1 may have:
AVERNA,ROBERT C

Because no ampersand, it should just return empty space in whatever column the calculation is performed in.

Thanks for response.

wow thanks for the quick reply. It worked.