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
|