extract numbers only

[samasker]

I'm new to excel . I have 64695 raw that have data contain numbers and text . I need to get each number in separate column . Data in each row like
Id_text1 text1 [id_text2 text2 [number]]
Notice : I'd for text1 and text2 is 18 digits but number is change every time with not specific digits . I mean sometimes .01 , .09987655 then .06868743555 and so on

I need to extract number start with 7.12045E+ in a column that related to the number 7120447980482 in a column with last number before close brackets which is here 0.09370036 and if there is empty brackets put zero in both number .
example of data
in attach file

Thanks in advance

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

[samasker]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

thanks . i did it

[FDibbins]

Thanks. What would some sample answers look like?

[samasker]

data which like 712044793858097000 []
i need to
712044793858097000 0 0
and data
712044793845698000 712044789659787268 1.0
these numbers for measuring similarity score between two text . i need to extract numbers to represent the relation between those ids and similarity score in a curve

[FDibbins]

Put that in your sample workbook please, so we can see what you want

[samasker]

sorry i didn't read it carefully , i put it in sheet2

[samasker]

Put that in your sample workbook please, so we can see what you want

excuse me , Did you get what i need ?

[samasker]

any help please

[FlameRetired]

samasker,

What FDibbins is asking for is a sample Excel workbook upload (and please no pictures or screenshots. They almost never tell enough of the story.)

To attach a file to your post,

• click “Go Advanced” (next to Post Quick Reply – bottom right),
• scroll down until you see “Manage Attachments”, click that,
• click “Browse”.
• select your file(s)
• click “Upload”
• click “Close window”
• click “Submit Reply”

The file name will appear at the bottom of your reply.

[AlKey]

Hi samasker,
try this
Enter in D1 and copy down

Please Login or Register  to view this content.

Enter in E1 and copy down

Please Login or Register  to view this content.

Enter in F1 and copy down

Please Login or Register  to view this content.

Please see attached file.

[newdoverman]

This is my interpretation of your problem:
Enter in D1 and fill down (format as NUMBER with 0 decimal places):

Please Login or Register  to view this content.

Enter in E1 and fill down:

Please Login or Register  to view this content.

Enter in F1 and fill down:

Please Login or Register  to view this content.