+ Reply to Thread
Results 1 to 2 of 2

String with words and numbers

  1. #1
    Registered User
    Join Date
    06-01-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    String with words and numbers

    Hi all,

    I am using VBA in Excel 2010. I have a String:

    Bank Charges 238.12 0.00 268.12 30.00

    I would like to split the words and dump the rest. Keep in mind I have a long text file I am looping through, so I need to use wildcard flags somehow. Any ideas?

    Thanks,

  2. #2
    Valued Forum Contributor StevenM's Avatar
    Join Date
    03-23-2008
    Location
    New Lenox, IL USA
    MS-Off Ver
    2007
    Posts
    910

    Re: String with words and numbers

    It is unclear to me what you are asking.
    Do you want to delete every word which is not alphabetic?
    So that "Bank Charges" would remain, but the rest would go?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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