Need a Function
 

I need to retrieve a character value from a given position within a text
string, how would I do that?

For example, I want to pull the value of the 4th character form the word
Charlie. The value would be r. What function does this?

Find and Search only return the position number of the specified character.

Thanks

Need a Function
 

You would use the method described in your other post!!

Please don't multipost

"Charlie" wrote:

I need to retrieve a character value from a given position within a text
string, how would I do that?

For example, I want to pull the value of the 4th character form the word
Charlie. The value would be r. What function does this?

Find and Search only return the position number of the specified character.

Thanks

Need a Function
 

See your other post. Multi-posting is not necessary in these groups.

Regards,
Fred.

"Charlie" wrote in message
...
I need to retrieve a character value from a given position within a text
string, how would I do that?

For example, I want to pull the value of the 4th character form the word
Charlie. The value would be r. What function does this?

Find and Search only return the position number of the specified
character.

Thanks

Need a Function
 

Hi,

Haven't checked your other post but...

=MID(A1,4,1)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Charlie" wrote:

I need to retrieve a character value from a given position within a text
string, how would I do that?

For example, I want to pull the value of the 4th character form the word
Charlie. The value would be r. What function does this?

Find and Search only return the position number of the specified character.

Thanks

Need a Function
 

=MID(string,startnum,numchars)

=MID("Charlie",4,1)

Or =MID(A1,4,1) if Charlie is in A1


Gord Dibben MS Excel MVP

On Tue, 23 Jun 2009 07:34:01 -0700, Charlie
wrote:

I need to retrieve a character value from a given position within a text
string, how would I do that?

For example, I want to pull the value of the 4th character form the word
Charlie. The value would be r. What function does this?

Find and Search only return the position number of the specified character.

Thanks