Need 9th Charachter from LEFT in text string

**floridagunner** · 04-27-2011, 11:16 AM

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

**tlafferty** · 04-27-2011, 11:18 AM

Please Login or Register  to view this content.

**tigeravatar** · 04-27-2011, 11:18 AM

floridagunner,

Try this:
=RIGHT(LEFT(A1,10),1)

Hope that helps,
~tigeravatar

**floridagunner** · 04-27-2011, 11:28 AM

Thank You both, tigeravatar and tlafferty!!

Both Formulas worked perfectly

**tlafferty** · 04-27-2011, 11:33 AM

Please consider marking your post closed:
To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

Also, if you're so inclined, you can add to reputation by clicking the scale button to the right of a user's name to say thank you.