Thread: Need a Function
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default 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