Excel formula to extract only number from right of text string

[mayurthakor13]

Hello,
My data in one column is as follows:

TABLE OF CONTENTS .........................................................................................................6

LIST OF TABLES ...........................................................................................................................11

GLOSSARY OF ABBREVIATIONS AND DEFINITION OF TERMS .......................................102

I am looking for an excel formula to extract the numbers from right in another column.
Thanks in advance.

 

[Peter_SSs]

Would this work for you?

23 03 05.xlsm
	A	B
1	TABLE OF CONTENTS .........................................................................................................6	6
2	LIST OF TABLES ...........................................................................................................................11	11
3	GLOSSARY OF ABBREVIATIONS AND DEFINITION OF TERMS .......................................102	102
Num

Cell Formulas
Range	Formula
B1:B3	B1	=SUBSTITUTE(RIGHT(A1,9),".","")+0

 

[mayurthakor13]

Would this work for you?

23 03 05.xlsm
	A	B
1	TABLE OF CONTENTS .........................................................................................................6	6
2	LIST OF TABLES ...........................................................................................................................11	11
3	GLOSSARY OF ABBREVIATIONS AND DEFINITION OF TERMS .......................................102	102
Num

Cell Formulas
Range	Formula
B1:B3	B1	=SUBSTITUTE(RIGHT(A1,9),".","")+0

It worked !!!!
Thank you so much @Peter_SSs for your quick reply

 

[Peter_SSs]

You're welcome. Glad to help. Thanks for the follow-up.