Results 1 to 5 of 5

Need 9th Charachter from LEFT in text string

Threaded View

  1. #1
    Registered User
    Join Date
    07-13-2007
    Posts
    50

    Need 9th Charachter from LEFT in text string

    Hello,

    I am looking for help with a formula. What I want is a formula that will give me the 10th character in a text string. For example if I have the following text string:

    A.00578.158

    The formula should return 1 as that is the 10th character in the string (also including decimals)

    I used the formula = LEFT(A1,10) but that returned the entire text string up to the 10th character = A.00578.1

    I just need something that will return the 10th character from the left.

    Thanks
    Last edited by floridagunner; 04-27-2011 at 11:28 AM.

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