parse into rows

  1. M

    Parsing Number sets to determine rows.

    I am working with an Excel sheet where I need to take numbers from a cell and then parse them to determine what rows to run. An example of the data would be something like this: 2,5-10,20-27 I need to figure out how to build an array of the numbers to determine the correct rows to run. So the...
  2. M

    Parse APT, #, Suite from Address

    In Excel 2010 need to have the apt number removed from the address 1 and stored in address 2. EXAMPLE: "8562 WASHINGTON AVE # 8" needs to be separated into two cells. I'm using the function below but need to address "APT" and "Suite" also somehow...
  3. J

    Address Formulas: How to separate ### from an address.

    How do you separate ### from address. I am trying to parse into rows a full address. Separating the number into a separate column, Street name into a separate column. Any assistance would be appreciative.
  4. J

    Data sorting Questions...

    Hey Excel Ninjas... I have been a silent worshipper of this site for a while but now I have to ask something... I have an issue with a lot of text that can only be dumped by the sytem into one column. The only problem is that it needs to be parsed and sorted by a bunch of different things. I...
  5. I

    how to count within a cell

    I need to count the number of commas within a cell so I can insert the proper number of rows below before I parse the value into separate rows. For instance, box, animal, elephant, wood, storage I need to know that there are 4 commas. So I can then insert 4 rows below the line and run the...

Watch MrExcel Video

This Week's Hot Topics

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
Top