Help with MID formula

[Luc]

Hi,

I've managed to extract some text from a string, but i want to convert this
to a number now.

So for example:

Cell A1 has "Adj001"

I used =MID(A1,4,3) to extract 001, but excel views this as text. can i
convert 001 to a number?

Thanks,

Luc

 

[Frank Kabel]

Hi
try
=--MID(A1,4,3)

 

[Luc]

Thanks Frank.

is that two minus signs?

when i put it in i get #VALUE!

 

[Frank Kabel]

Hi
then your cell A1 contains other values as well. Works for me.
You may also try:
=VALUE(MID(A1,4,3))

 

[Luc]

Hello,

That second formula worked.

Thanks a lot for that Frank.

Regards,
Luc