Extract data from a cell

[nagovind]

Dears,

Kindly advise how to extract the data in a cell to 2 different cells as shown. Kindly do the needful. Attached is the excel sheet.
Regards
Govind

 

[AliGW]

=--MID(D9,FIND("=",D9)+2,7)

and

=MID(D9,FIND(",",D9)+2,8)

 

[nagovind]

Dear AliGW,

Thank you very much, its done
Regards

 

[nagovind]

Dear AliGW,
Is it possible to trim the °
Instead of -163.94° is it possible to display only -163.94
Thank you

 

[AliGW]

=--SUBSTITUTE(MID(D9,FIND(",",D9)+2,8),"°","")

 

[nagovind]

Thank you, understood the concept as well

 

[AliGW]

Great!

Just in case, the double negative or unary (--) forces the result to be a numerical value (and right-aligned) instead of a text string (left-aligned).

 

[nagovind]

Dear AliGW,
Please advise
I have attached the excel file
The input field is highly dynamic
Need to extract the data - only numerical data from the input cell in the desired format as shown. Is there is any way out? please advise

 

[AliGW]

This for the first value:

=--LEFT(MID(D9,FIND("=",D9)+2,7),FIND(" ",MID(D9,FIND("=",D9)+2,7))-1)

This still works for the second value:

=--SUBSTITUTE(MID(D9,FIND(",",D9)+2,8),"°","")

 

[bosco_yip]

Or,

In E9, copied right to F9. and all copied down :

=LOOKUP(9^9,0+MID($D9,FIND(IF(COLUMN(A1)=1,"=",","),$D9)+1,ROW($1:$99)))

Regards
Bosco

 

[nagovind]

Dear AliGW & Bosco,
Thank you very much for your help.
It's working.
Regards