Thread: need formula for text to columns

I have THOUSANDS of lines like this:

Uncle Benʼs products Save $1/4 (3/11/12)
Whiskas Dry Food for Cats Save $1/1 (3/17/12)

I need to seperate them, I've tried the text to columns wizard but its not doing what I need. Is there a formula I could use?!

Here's what I need:


(column a)Uncle Benʼs products (column b) Save $1/4 (column c) (3/11/12)
(column a)Whiskas Dry Food for Cats (column b) Save $1/1 (column c) (3/17/12)

thanks for any help

1. Replace:
Find what:= save
Replace with := * save
Replace all
2. Text to Columns, delimited, other,"*"