Thread: return a character at a certain position in a string of text
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default return a character at a certain position in a string of text
On Sun, 22 Apr 2007 20:56:00 -0700, Miranda
wrote:

There is a cell will a 15-character string of text in it. I would like to
return the character at position 7. How do I do this?

=mid(string,7,1)


--ron
Reply With QuoteReply With Quote