Extract data from a text string based on criteria

[Bravo33]

I want extract multiple data from a cell.

cell A1 contains the following data:-

S=123.45 M=67.68 O=10.12

I want to copy 123.45 to cell B1 and then 67.68 to cell C1 and so on.

I have hundreds of lines of data in this format that I need to extract.

Solutions greatly appreciated.

 

[GlennUK]

What about doing text to columns on column A, delimited on "=" and space, and then deleting unwanted columns?

 

[Bravo33]

Tried that and the problem I should have mentioned is that the data can be in any order ie S= could be at the end.

 

[GlennUK]

So, you are saying that the S value is to go into column B, the M value into column C and the O value into column D?

 

[Phanmore]

This should do it:

=MID(A16,FIND("S",A16)+2,FIND(" ",A16&" ",FIND("S",A16))-FIND("S",A16)-2)

Just replace the "S" with any letter your looking for and A16 to the cell you are looking at.

 

[Bravo33]

This should do it:

=MID(A16,FIND("S",A16)+2,FIND(" ",A16&" ",FIND("S",A16))-FIND("S",A16)-2)

Just replace the "S" with any letter your looking for and A16 to the cell you are looking at.

Many thanks ...................Works a treat!