Thread: return a character at a certain position in a string of text
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default return a character at a certain position in a string of text
Try this:

=MID(A1,7,1)

Biff

"Miranda" wrote in message
...
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?


Reply With QuoteReply With Quote