Easy question!

[Overkill32]

Is there a function that can return the value of a specific character in a string or number acording to its position? Like i have the string "Hello", what can i use to return the third character "l"? Or if i have the number "100456", how can i return the third character (which is 0).

I know it's possible using a combination of left() or right() function but I was wondering if there were any user friendly function that would achieve the same task?

 

[yytsunamiyy]

Try:

=Mid(A1;3;1) to return the third character in cell A1

 

[GK039]

Hi

Try the MID function instead. eg:=MID(A1,3,1) would return "L" from Hello

George

Is there a function that can return the value of a specific character in a string or number acording to its position? Like i have the string "Hello", what can i use to return the third character "l"? Or if i have the number "100456", how can i return the third character (which is 0).

I know it's possible using a combination of left() or right() function but I was wondering if there were any user friendly function that would achieve the same task?

 

[pedie]

kinda funny but try..
=RIGHT(RIGHT(LEFT(A1,3),2),1)

if you've just 1 letter, it will return 1 letter, 2 then 2, 3 then 3, 4 then 3 and so on..

 

[T. Valko]

Is there a function that can return the value of a specific character in a string or number acording to its position? Like i have the string "Hello", what can i use to return the third character "l"? Or if i have the number "100456", how can i return the third character (which is 0).

I know it's possible using a combination of left() or right() function but I was wondering if there were any user friendly function that would achieve the same task?

The MID function...

A1 = some entry like: Hello

=MID(A1,3,1)

Returns l

A1 = 100456

=MID(A1,3,1)

Returns "0" as a TEXT number. It's not the numeric value 0.

If you need to parse numeric strings and you want the returned value to remain a numeric value then:

A1 = 100456

=--MID(A1,3,1)

Returns numeric 0

 

[GK039]

complicated but funny indeed

kinda funny but try..
=RIGHT(RIGHT(LEFT(A1,3),2),1)

if you've just 1 letter, it will return 1 letter, 2 then 2, 3 then 3, 4 then 3 and so on..