extract a fixed number

[kisanvikas2015]

Hi all,

From a list of numbers; I want output like shown in Ans column till 5 digits.

A1) Numbers B1) Ans
A2) 123456789 B2) 123456789
A3) 1234567 B3) 1234567
A4) 123 B4)
A5) 12345 B5) 12345

Regards,
Vikas

[Glenn Kennedy]

Assunming that the data starts in A1 and contains A2) 123456789, try this:
=MID(A1,FIND(")",A1)+1,255)+0

[ashishmehra2010]

Hi Vikas

Try using

Please Login or Register  to view this content.

Regards,
AM

[Glenn Kennedy]

Both ashishmehra and I have made very different interpretations of what you want. It would have been easier if it was clearer what was in what columns!!