Results 1 to 12 of 12

Return Location of Alpha/Numeric String

Threaded View

Greg777 Return Location of... 10-27-2011, 03:43 PM
davegugg Re: Return Location of... 10-27-2011, 03:47 PM
JBeaucaire Re: Return Location of... 10-27-2011, 03:48 PM
Greg777 Re: Return Location of... 10-27-2011, 03:55 PM
Greg777 Re: Return Location of... 10-27-2011, 04:16 PM
davegugg Re: Return Location of... 10-27-2011, 04:21 PM
shg Re: Return Location of... 10-27-2011, 04:30 PM
JBeaucaire Re: Return Location of... 10-27-2011, 05:25 PM
yay_excel Re: Return Location of... 10-27-2011, 05:25 PM
Greg777 Re: Return Location of... 10-27-2011, 05:46 PM
JBeaucaire Re: Return Location of... 10-27-2011, 07:24 PM
Greg777 Re: Return Location of... 10-27-2011, 08:18 PM
  1. #1
    Registered User
    Join Date
    08-21-2010
    Location
    Omaha, NE
    MS-Off Ver
    Excel 2003
    Posts
    45

    Return Location of Alpha/Numeric String

    Hello,

    How can I formulaically find the starting location of a string that is letter + 6 numbers + letter in a longer string?

    As in,

    Find 'a123456b' from po34ksa123456b95043, with an answer of 7.

    I was thinking FIND() with wild cards, but the wold cards would have to specify whether it was text or numeral. Any help appreciated!

    Greg
    Last edited by Greg777; 10-27-2011 at 08:18 PM.

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