Extract Digits from string

[segran]

Hi,

I have strings of varying lengths. For example:


1.01 Property rights.........................................................................98
1.02 Intellectual property protection .............................................107
1.03 Diversion of public funds.......................................................103
1.04 Public trust of politicians .........................................................89
1.05 Irregular payments and bribes...............................................104
1.06 Judicial independence ...........................................................118

I want to extract the numbers only in a column, for example:

98
107
103
89
104
118

If I could extract the name of the measure as well, followed by the digits in another column, that would be appreciated, example:

Property rights 98
Intellectual property protection 107
etc


Thanking you for your assistance.

 

[jbeaucaire]

Try this:

Excel Workbook
	A	B	C
1	1.01 Property rights.........................................................................98	Property rights	98
2	1.02 Intellectual property protection .............................................107	Intellectual property protection	107
3	1.03 Diversion of public funds.......................................................103	Diversion of public funds	103
4	1.04 Public trust of politicians .........................................................89	Public trust of politicians	89
5	1.05 Irregular payments and bribes...............................................104	Irregular payments and bribes	104
6	1.06 Judicial independence ...........................................................118	Judicial independence	118
Sheet1

 

[segran]

Thank You