Selecting characters from a cell

[doublej41]

Hi All,

A piece of software I use enters data into Excel in the format shown below. Is there a way that I can select the decimal from the each cell, ignoring the number and semi colon before it?

Excel Workbook
	A
1	0; 0.5
2	1; 5.2
3	2; 11.9
4	3; 24.2
5	4; 41.8
6	5; 62.5
7	6; 88.8
8	7; 121.8
9	8; 160.0
10	9; 223.9
11	10; 310.9
12	9; 226.7
13	8; 161.6
14	7; 122.2
15	6; 89.1
16	5; 63.2
17	4; 43.8
18	3; 24.8
19	2; 10.7
20	1; 4.70
21	0; 0.2
Sheet1

 

[syntaxed]

How about with this formula:
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1))

 

[doublej41]

Hi Syntaxed, the formula works great.

Many thanks for your reply.