Hi All,

I am trying to return a text value to a cell if another cell contains the Dollar symbol ($).

e.g.

George $30
Bill
Harry
John $30

I would like to paste a formula next to each one that returns "Cash" if there is a $ Symbol or "Free" if it doesn't.

Any help would be appreciated.

Cheers

Dee