separate cells

  1. T

    Potential Cell Character Limitation causing formula failure

    Hi Everyone, Perhaps I don't understand the separation formula I using well enough, but everything seemed to be working nicely up until data was entered beyond a certain point in a cell. Overall, I am using data imported from another source that is separated by double asterisks between terms...
  2. S

    Extract Characters from 1 string in separate cells

    I have a JSON text result from an API, given below. {"visit":"1","paid":"0","repeatPat":0} I need the numbers to be extracted in 3 separate cells. Please assist.
  3. S

    Identify cells that end in 5 numbers

    Hi - I have a column which has names of businesses but some of them have the zip code attached to them. For example most cells are just ABC Company 123 Company Def Company But some are ABC Company90210 123 Company10011 Def Company20007 In all the cells that have zip codes, they are always 5...
    • shivus
    • Thread
    • character string exact match formula & filter if then separate cells
    • Replies: 3
    • Forum: Excel Questions
  4. R

    Average with missing data

    Hello I am one f those people that can normally solve an excel problem with a search. Unfortunately, I can't find what I am looking for this time. Please help :o) Here is my problem, I need to be able to create an average total that skips any missing information. For example, if I have four...
    • ReeGiGi
    • Thread
    • average missing data missing values not adjoining cells separate cells
    • Replies: 4
    • Forum: Excel Questions

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