Results 1 to 3 of 3

lookup first letter in cell.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-10-2008
    Location
    SW Ontario, Canada
    MS-Off Ver
    Excel 365
    Posts
    154

    lookup first letter in cell.

    Is there a way to lookup the first letter of a word in the cell.
    I am trying to keep my sheet as small as possible for emailing. It would help to narrow down the possible lookup combinations.
    For example I only need to know if it starts with T, P, or V. I don't need to know the rest of the word. eg TMO, TAEFA, P1284, VTL3D etc....
    thanks
    Last edited by kriminaal; 01-19-2009 at 10:16 AM.

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