Thread: Pick numbers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Pick numbers

You'd use MID.

=MID("51900125",3,1)

Is that what you're looking for?
--
HTH,

Barb Reinhardt



"Mia" wrote:

Hi,

If I have a string of numbers, for example 51900125 and I want to pick
number three (in this example 9) in a specified cell, what shall i type.
I have tried Left and right but then I got a string of figures.
Do anuone know how to solve this?


--
Best regards
Mia