separate numbers

  1. J

    Extract two sets of numbers between text in cell

    Hello, I have the text in a cell: eFine: 2404852 eFood: 12827 I wanted to extract the numbers and place them in two separate columns: Test 1 Amp 2404852 12827 I tried this formula but I got all the numbers: 240485212827 Can you help me separate out the numbers to get the table...
  2. K

    How do you separate numbers and words of varying lengths into columns in Excel 2003?

    How do I separate the Fund Name, Ticker and Net Flows in this list, which are currently in one column, into three separate columns with Excel 2003? I got it from this site, ETF Fund Flows Tool - IndexUniverse.com, and wanted to reproduce it for a newspaper publication. I couldn't find an...
  3. H

    Separate the 3 digit nos.

    I get 3 digit +ve integer nos. In subsequent 3 cells, I want them SEPARATELY as: For 789 7 8 9 For 90 0 9 0 For 5 0 0 5
  4. P

    How to Find / Separate a Number from Message Text

    Is there a way to find and seperate a number from message text? These are all errors within the system. Ultimately I would like to identify material numbers that are generating multiple errors. Below are several examples. In some cases, the number is not completely seperated (adjoined to...
  5. S

    Separating mass groups of numbers

    Hey guys. I am trying to separate a huge group of phone numbers from one cell into individual cells in a column. the numbers are currently separated by a semicolon. Is there an easy way to perform this action?? Thanks

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top