Identifying Decimal within String

[jgallan]

Hi,

This is my first visit to Exceltip.com so i hope someone can help. I'm from Sydney, Australia and need help with some data cleaning.

I have a column of data and within each cell is a string of varying length and characters. However, somewhere within that string will be a decimal value, to either 1 or 2 decimal values. I need to extract that decimal value and copy it to the adjacent cell.


Example

Cell C:77 contains: "Subject: Re: 4.10 Workplace Amenities"

I need cell B:77 to display: "4.10"


Similarly,

Cell C:134 contains: "Subject: 12.1 Safety Factors"

I need cell B:134 to display: "12.1"



The number is always in the form of X.Y or XX.YY

where X is between 1 and 14
and Y is between 1 and 16


is there a way of doing this without needing to develop an extensive macro?

Looking fwd to your help...

Kind regards,

Jeremy

[Bryan Hessey]

Is this a double post ?
see the answer in your other post

Hi,

This is my first visit to Exceltip.com so i hope someone can help. I'm from Sydney, Australia and need help with some data cleaning.

I have a column of data and within each cell is a string of varying length and characters. However, somewhere within that string will be a decimal value, to either 1 or 2 decimal values. I need to extract that decimal value and copy it to the adjacent cell.


Example

Cell C:77 contains: "Subject: Re: 4.10 Workplace Amenities"

I need cell B:77 to display: "4.10"


Similarly,

Cell C:134 contains: "Subject: 12.1 Safety Factors"

I need cell B:134 to display: "12.1"



The number is always in the form of X.Y or XX.YY

where X is between 1 and 14
and Y is between 1 and 16


is there a way of doing this without needing to develop an extensive macro?

Looking fwd to your help...

Kind regards,

Jeremy