+ Reply to Thread
Results 1 to 2 of 2

how to identify string and integer within one piece of data

  1. #1
    Registered User
    Join Date
    02-12-2013
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    68

    how to identify string and integer within one piece of data

    hi everyone, does anyone know how to write code that would identify string and integer within one piece of data from a textbox, so that i can use the string part of the data, thank you!

  2. #2
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: how to identify string and integer within one piece of data

    try this piece of code,


    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Taking an integer out of a string
    By Mike112 in forum Excel General
    Replies: 13
    Last Post: 06-01-2012, 02:46 PM
  2. Replies: 9
    Last Post: 11-12-2010, 05:51 AM
  3. Identify 2 or 3 Conescutives in a string of data
    By ctrapper in forum Excel General
    Replies: 9
    Last Post: 10-25-2010, 10:42 AM
  4. need to extract piece of string
    By als86 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-24-2009, 09:40 AM
  5. VBA to identify last digit in integer
    By brucemc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2006, 02:00 AM

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