+ Reply to Thread
Results 1 to 2 of 2

need formula for text to columns

  1. #1
    Registered User
    Join Date
    01-28-2012
    Location
    new orleans, la
    MS-Off Ver
    Excel 2003
    Posts
    1

    Question 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
    Last edited by NOLady; 01-28-2012 at 05:48 PM. Reason: the boss made me ;)

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,612

    Re: new here and need help

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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1