• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Extract data from a cell

nagovind

Member
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

upload_2019-1-3_12-2-46.png
 

Attachments

  • Extract data as desired.xlsx
    8.1 KB · Views: 8
Dear AliGW,
Is it possible to trim the °
Instead of -163.94° is it possible to display only -163.94
Thank you
 
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).
 
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

upload_2019-1-7_18-8-5.png
 

Attachments

  • How to get number from any position as required.xlsx
    10.3 KB · Views: 3
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),"°","")
 
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
 

Attachments

  • How to get number from any position as required(1).xlsx
    11.7 KB · Views: 5
Back
Top