+ Reply to Thread
Results 1 to 2 of 2

String function to get selective text from long string

  1. #1
    Registered User
    Join Date
    03-25-2011
    Location
    Rockville, Maryland
    MS-Off Ver
    Excel 2007
    Posts
    3

    String function to get selective text from long string

    I haven't used the string function since old days of Lotus but seem to remember that I can find a special character ($), move right until reaching a blank space, then copy those characters between special and blank and copy to a cell. Then continue to find same special character again, same process and copy to cell in row below. Specifically here I am trying to get the dollar amounts from this string, put them in rows to add up.
    3/24/2011Card Purchase MAIN STREET MARKET GAITHERSBURG MD * $9.53 * 3/24/2011Card Purchase ACE HARDWARE INC #320QPS GAITHERSBURG MD * $14.56 * 3/23/2011Card Purchase ACME SERVICE STATION GAITHERSBURG MD * $7.86 * 3/23/2011Card Purchase RESTAURANT GAITHERSBURG MD * $15.89 * 3/23/2011Card Purchase MID-TOWN MARKET GAITHERSBURG MD

  2. #2
    Valued Forum Contributor
    Join Date
    05-21-2009
    Location
    Great Britain
    MS-Off Ver
    Excel 2003
    Posts
    550

    Re: String function to get selective text from long string

    Call the InStr and Mid functions in a loop.

+ 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