left find

  1. P

    Extract variable data string

    Hi, I'm trying to extract sale order numbers in a certain format but they have recently jumped up in character length so current formula doesn't work for all cells. Current formula is =MID(P2,4,7) This worked fine where number was 0001234567/00100. Now we have numbers such as 0123456789/00100...
  2. S

    Extracting 1st word of a text string delimited by 1 of 2 characters

    I have strings that I need to pull the first word out of. The problem is, that the first word is either delimited by a space, or an underscore. I have been using the below formula to find the first word if separated by a space, but unclear how to add the OR to look for an underscore...
    • SG51090
    • Thread
    • deliminate if formula left find space underscore
    • Replies: 4
    • Forum: Excel Questions
  3. K

    Pull text between 2 characters in cell

    Hi All, I'm sure someone has asked a similar question before, but tbh, I really wanted to get a direct answer to my specific question, so I don't have to spend time figuring out how to retrofit another answer. :P I would like to pull out the contents from the middle of a cell between two...

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