right function

  1. C

    parsing apart codes with differing lengths

    I have a list of numbers 0010001 0090001 10001 0110001 020001 I need to split these apart with the last four digits being in one column and the rest in another. example: column B column C 001 0001 009 0001 1...
  2. B

    If cell is blank, fill in with cell above

    I have a list that was previously fully filled in, but I had to go through and insert many rows. Now with those inserted rows I want to insert the same text that is in the cell above. BQ5 - Anderson BQ6 - Anderson BQ7 - Anderson BQ8 - BQ9 - Anderson BQ10 - Anderson BQ11 - BQ12 - Rochester...
    • BMR
    • Thread
    • excel help function help replace right function
    • Replies: 3
    • Forum: Excel Questions
  3. J

    Find Location of a Specific Character in a Cell With Multiple Occurrences of that Character

    I'm using Excel 2007. I'm looking for a way to reference a specific cell to determine the exact location of a specific character that occurs multiple times in the string. In this case I want the numeric location of the last occurrence of the character "-" so I can extract all the text to the...
  4. C

    Finding Text Between Two Instances

    Hi Everyone, I am trying to figure out how to return the text between two different instances of the same symbol. For example, I have this in a cell: 100% Cotton / 55.0 in / 3.2 oz/sq yd / 120 x 70 / 40 NE x 40 NE / Yarn Dye I want to be able to to extract all the information between the fifth...
  5. klynshoe

    Delete characters from cell in a list

    How do I easily delete each instance of "J##" from each cell in this list? <TABLE style="WIDTH: 133pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=177 border=0><COLGROUP><COL style="WIDTH: 133pt; mso-width-source: userset; mso-width-alt: 6473" width=177><TBODY><TR...

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