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
Bookmarks