Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 4 of 4

Thread: Extract The First Letter Of A String

  1. #1
    Join Date
    7th March 2007
    Location
    Omaha, Ne, USA
    Posts
    37

    Extract The First Letter Of A String

    How can I extract the first letter of a string?

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2007
    Location
    Omaha, Ne, USA
    Posts
    37

    Re: Extract The First Letter Of A String

    nevermind, got it

    VB:
    newString = left(originalString, 1) 
    
    
    Where 1 is the number of characters you want to extract.

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    5th April 2007
    Location
    Fort Collins Colorado
    Posts
    103

    Re: Extract The First Letter Of A String

    there is also a worksheet function that does the same:

    =left(A1,1)

    where A1 is a cell containing the string to evaluate (you can also input the string directlly into this formula instead of the cell reference if you want to.)

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th December 2011
    Posts
    1

    Re: Extract The First Letter Of A String

    LEFT(TRIM(B1),1)

    By using the TRIM function, you will remove all leading spaces at the beginning of the string.
    By using the LEFT function on the previously trimmed string, the returned character will be the first non-blank character from the string, be it a letter or number.

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Extract First Letter Of Words In Cell
    By HarryFrohlich in forum EXCEL HELP
    Replies: 2
    Last Post: June 5th, 2008, 19:31
  2. Replies: 6
    Last Post: May 7th, 2006, 00:07
  3. extract 2 letter word
    By opeyemi1 in forum EXCEL HELP
    Replies: 11
    Last Post: October 21st, 2005, 22:35
  4. Replies: 9
    Last Post: July 3rd, 2004, 04:14
  5. How to get a letter out of a string
    By e7macka in forum EXCEL HELP
    Replies: 3
    Last Post: May 11th, 2004, 17:42

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
  •  
porno